/*
*
* MasterOrderInfoExample.java
* @author yaokan
* @date 2021-05-26 13:14:01
*/
package com.steel.yfmall.cloud.assistant.po.oms;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class MasterOrderInfoExample {
    /**
     * master_order_info
     */
    protected String orderByClause;

    /**
     * master_order_info
     */
    protected boolean distinct;

    /**
     * master_order_info
     */
    protected List<Criteria> oredCriteria;

    private Integer limit;

    private Integer offset;

    private String groupByClause;

    private String selectFields;

    /**
     * 构造查询条件:master_order_info
     * @Title: MasterOrderInfoExample
     * @Description: ( )
     * @return 返回类型 null
     * @date 2021-05-26 13:14:01
     */
    public MasterOrderInfoExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * 设置排序字段:master_order_info
     * @Title: setOrderByClause
     * @Description: ( 设置排序字段 )
     * @param 参数说明 类型:String	名称:orderByClause 排序字段
     * @return 返回类型 null
     * @date 2021-05-26 13:14:01
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     * 获取排序字段:master_order_info
     * @Title: getOrderByClause
     * @Description: ( 获取排序字段 )
     * @return 返回类型 java.lang.String
     * @date 2021-05-26 13:14:01
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * 设置过滤重复数据:master_order_info
     * @Title: setDistinct
     * @Description: ( 设置过滤重复数据 )
     * @param 参数说明 类型:boolean	名称:distinct 是否过滤重复数据
     * @return 返回类型 null
     * @date 2021-05-26 13:14:01
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     * 是否过滤重复数据:master_order_info
     * @Title: isDistinct
     * @Description: ( 是否过滤重复数据 )
     * @return 返回类型 boolean
     * @date 2021-05-26 13:14:01
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     * 获取当前的查询条件实例:master_order_info
     * @Title: getOredCriteria
     * @Description: ( 获取当前的查询条件实例 )
     * @return 返回类型 java.util.List<Criteria>
     * @date 2021-05-26 13:14:01
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     *:master_order_info
     * @Title: or
     * @Description: ( )
     *
     * @param 参数说明 类型:Criteria	名称:criteria 过滤条件实例
     * @return 返回类型 null
     * @date 2021-05-26 13:14:01
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     *:master_order_info
     * @Title: or
     * @Description: ( )
     *
     * @return 返回类型 Criteria
     * @date 2021-05-26 13:14:01
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     * 创建一个查询条件:master_order_info
     * @Title: createCriteria
     * @Description: ( 创建一个查询条件 )
     * @return 返回类型 Criteria
     * @date 2021-05-26 13:14:01
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     * 内部构建查询条件对象:master_order_info
     * @Title: createCriteriaInternal
     * @Description: ( 内部构建查询条件对象 )
     * @return 返回类型 Criteria
     * @date 2021-05-26 13:14:01
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * 清除查询条件:master_order_info
     * @Title: clear
     * @Description: ( 清除查询条件 )
     * @return 返回类型 null
     * @date 2021-05-26 13:14:01
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void limit(Integer offset, Integer limit) {
        this.offset = offset;
        this.limit = limit;
    }

    public Integer getLimit() {
        return limit;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return offset;
    }

    public void setGroupByClause(String groupByClause) {
        this.groupByClause = groupByClause;
    }

    public String getGroupByClause() {
        return groupByClause;
    }

    public void setSelectFields(String selectFields) {
        this.selectFields = selectFields;
    }

    public String getSelectFields() {
        return selectFields;
    }

    /**
     * @title master_order_info表的实体类
     * @description master_order_info
     * @version 1.0
     * @author yaokan
     * @date 2021-05-26 13:14:01
     */
    protected abstract static class GeneratedCriteria implements java.io.Serializable {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andMasterOrderSnIsNull() {
            addCriterion("master_order_sn is null");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnIsNotNull() {
            addCriterion("master_order_sn is not null");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnEqualTo(String value) {
            addCriterion("master_order_sn =", value, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnNotEqualTo(String value) {
            addCriterion("master_order_sn <>", value, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnGreaterThan(String value) {
            addCriterion("master_order_sn >", value, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnGreaterThanOrEqualTo(String value) {
            addCriterion("master_order_sn >=", value, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnLessThan(String value) {
            addCriterion("master_order_sn <", value, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnLessThanOrEqualTo(String value) {
            addCriterion("master_order_sn <=", value, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnLike(String value) {
            addCriterion("master_order_sn like", value, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnNotLike(String value) {
            addCriterion("master_order_sn not like", value, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnIn(List<String> values) {
            addCriterion("master_order_sn in", values, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnNotIn(List<String> values) {
            addCriterion("master_order_sn not in", values, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnBetween(String value1, String value2) {
            addCriterion("master_order_sn between", value1, value2, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnNotBetween(String value1, String value2) {
            addCriterion("master_order_sn not between", value1, value2, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andTransTypeIsNull() {
            addCriterion("trans_type is null");
            return (Criteria) this;
        }

        public Criteria andTransTypeIsNotNull() {
            addCriterion("trans_type is not null");
            return (Criteria) this;
        }

        public Criteria andTransTypeEqualTo(Integer value) {
            addCriterion("trans_type =", value, "transType");
            return (Criteria) this;
        }

        public Criteria andTransTypeNotEqualTo(Integer value) {
            addCriterion("trans_type <>", value, "transType");
            return (Criteria) this;
        }

        public Criteria andTransTypeGreaterThan(Integer value) {
            addCriterion("trans_type >", value, "transType");
            return (Criteria) this;
        }

        public Criteria andTransTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("trans_type >=", value, "transType");
            return (Criteria) this;
        }

        public Criteria andTransTypeLessThan(Integer value) {
            addCriterion("trans_type <", value, "transType");
            return (Criteria) this;
        }

        public Criteria andTransTypeLessThanOrEqualTo(Integer value) {
            addCriterion("trans_type <=", value, "transType");
            return (Criteria) this;
        }

        public Criteria andTransTypeIn(List<Integer> values) {
            addCriterion("trans_type in", values, "transType");
            return (Criteria) this;
        }

        public Criteria andTransTypeNotIn(List<Integer> values) {
            addCriterion("trans_type not in", values, "transType");
            return (Criteria) this;
        }

        public Criteria andTransTypeBetween(Integer value1, Integer value2) {
            addCriterion("trans_type between", value1, value2, "transType");
            return (Criteria) this;
        }

        public Criteria andTransTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("trans_type not between", value1, value2, "transType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIsNull() {
            addCriterion("order_type is null");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIsNotNull() {
            addCriterion("order_type is not null");
            return (Criteria) this;
        }

        public Criteria andOrderTypeEqualTo(Integer value) {
            addCriterion("order_type =", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotEqualTo(Integer value) {
            addCriterion("order_type <>", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeGreaterThan(Integer value) {
            addCriterion("order_type >", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("order_type >=", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeLessThan(Integer value) {
            addCriterion("order_type <", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeLessThanOrEqualTo(Integer value) {
            addCriterion("order_type <=", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIn(List<Integer> values) {
            addCriterion("order_type in", values, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotIn(List<Integer> values) {
            addCriterion("order_type not in", values, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeBetween(Integer value1, Integer value2) {
            addCriterion("order_type between", value1, value2, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("order_type not between", value1, value2, "orderType");
            return (Criteria) this;
        }

        public Criteria andRelatingOriginalSnIsNull() {
            addCriterion("relating_original_sn is null");
            return (Criteria) this;
        }

        public Criteria andRelatingOriginalSnIsNotNull() {
            addCriterion("relating_original_sn is not null");
            return (Criteria) this;
        }

        public Criteria andRelatingOriginalSnEqualTo(String value) {
            addCriterion("relating_original_sn =", value, "relatingOriginalSn");
            return (Criteria) this;
        }

        public Criteria andRelatingOriginalSnNotEqualTo(String value) {
            addCriterion("relating_original_sn <>", value, "relatingOriginalSn");
            return (Criteria) this;
        }

        public Criteria andRelatingOriginalSnGreaterThan(String value) {
            addCriterion("relating_original_sn >", value, "relatingOriginalSn");
            return (Criteria) this;
        }

        public Criteria andRelatingOriginalSnGreaterThanOrEqualTo(String value) {
            addCriterion("relating_original_sn >=", value, "relatingOriginalSn");
            return (Criteria) this;
        }

        public Criteria andRelatingOriginalSnLessThan(String value) {
            addCriterion("relating_original_sn <", value, "relatingOriginalSn");
            return (Criteria) this;
        }

        public Criteria andRelatingOriginalSnLessThanOrEqualTo(String value) {
            addCriterion("relating_original_sn <=", value, "relatingOriginalSn");
            return (Criteria) this;
        }

        public Criteria andRelatingOriginalSnLike(String value) {
            addCriterion("relating_original_sn like", value, "relatingOriginalSn");
            return (Criteria) this;
        }

        public Criteria andRelatingOriginalSnNotLike(String value) {
            addCriterion("relating_original_sn not like", value, "relatingOriginalSn");
            return (Criteria) this;
        }

        public Criteria andRelatingOriginalSnIn(List<String> values) {
            addCriterion("relating_original_sn in", values, "relatingOriginalSn");
            return (Criteria) this;
        }

        public Criteria andRelatingOriginalSnNotIn(List<String> values) {
            addCriterion("relating_original_sn not in", values, "relatingOriginalSn");
            return (Criteria) this;
        }

        public Criteria andRelatingOriginalSnBetween(String value1, String value2) {
            addCriterion("relating_original_sn between", value1, value2, "relatingOriginalSn");
            return (Criteria) this;
        }

        public Criteria andRelatingOriginalSnNotBetween(String value1, String value2) {
            addCriterion("relating_original_sn not between", value1, value2, "relatingOriginalSn");
            return (Criteria) this;
        }

        public Criteria andRelatingReturnSnIsNull() {
            addCriterion("relating_return_sn is null");
            return (Criteria) this;
        }

        public Criteria andRelatingReturnSnIsNotNull() {
            addCriterion("relating_return_sn is not null");
            return (Criteria) this;
        }

        public Criteria andRelatingReturnSnEqualTo(String value) {
            addCriterion("relating_return_sn =", value, "relatingReturnSn");
            return (Criteria) this;
        }

        public Criteria andRelatingReturnSnNotEqualTo(String value) {
            addCriterion("relating_return_sn <>", value, "relatingReturnSn");
            return (Criteria) this;
        }

        public Criteria andRelatingReturnSnGreaterThan(String value) {
            addCriterion("relating_return_sn >", value, "relatingReturnSn");
            return (Criteria) this;
        }

        public Criteria andRelatingReturnSnGreaterThanOrEqualTo(String value) {
            addCriterion("relating_return_sn >=", value, "relatingReturnSn");
            return (Criteria) this;
        }

        public Criteria andRelatingReturnSnLessThan(String value) {
            addCriterion("relating_return_sn <", value, "relatingReturnSn");
            return (Criteria) this;
        }

        public Criteria andRelatingReturnSnLessThanOrEqualTo(String value) {
            addCriterion("relating_return_sn <=", value, "relatingReturnSn");
            return (Criteria) this;
        }

        public Criteria andRelatingReturnSnLike(String value) {
            addCriterion("relating_return_sn like", value, "relatingReturnSn");
            return (Criteria) this;
        }

        public Criteria andRelatingReturnSnNotLike(String value) {
            addCriterion("relating_return_sn not like", value, "relatingReturnSn");
            return (Criteria) this;
        }

        public Criteria andRelatingReturnSnIn(List<String> values) {
            addCriterion("relating_return_sn in", values, "relatingReturnSn");
            return (Criteria) this;
        }

        public Criteria andRelatingReturnSnNotIn(List<String> values) {
            addCriterion("relating_return_sn not in", values, "relatingReturnSn");
            return (Criteria) this;
        }

        public Criteria andRelatingReturnSnBetween(String value1, String value2) {
            addCriterion("relating_return_sn between", value1, value2, "relatingReturnSn");
            return (Criteria) this;
        }

        public Criteria andRelatingReturnSnNotBetween(String value1, String value2) {
            addCriterion("relating_return_sn not between", value1, value2, "relatingReturnSn");
            return (Criteria) this;
        }

        public Criteria andRelatingRemoneySnIsNull() {
            addCriterion("relating_remoney_sn is null");
            return (Criteria) this;
        }

        public Criteria andRelatingRemoneySnIsNotNull() {
            addCriterion("relating_remoney_sn is not null");
            return (Criteria) this;
        }

        public Criteria andRelatingRemoneySnEqualTo(String value) {
            addCriterion("relating_remoney_sn =", value, "relatingRemoneySn");
            return (Criteria) this;
        }

        public Criteria andRelatingRemoneySnNotEqualTo(String value) {
            addCriterion("relating_remoney_sn <>", value, "relatingRemoneySn");
            return (Criteria) this;
        }

        public Criteria andRelatingRemoneySnGreaterThan(String value) {
            addCriterion("relating_remoney_sn >", value, "relatingRemoneySn");
            return (Criteria) this;
        }

        public Criteria andRelatingRemoneySnGreaterThanOrEqualTo(String value) {
            addCriterion("relating_remoney_sn >=", value, "relatingRemoneySn");
            return (Criteria) this;
        }

        public Criteria andRelatingRemoneySnLessThan(String value) {
            addCriterion("relating_remoney_sn <", value, "relatingRemoneySn");
            return (Criteria) this;
        }

        public Criteria andRelatingRemoneySnLessThanOrEqualTo(String value) {
            addCriterion("relating_remoney_sn <=", value, "relatingRemoneySn");
            return (Criteria) this;
        }

        public Criteria andRelatingRemoneySnLike(String value) {
            addCriterion("relating_remoney_sn like", value, "relatingRemoneySn");
            return (Criteria) this;
        }

        public Criteria andRelatingRemoneySnNotLike(String value) {
            addCriterion("relating_remoney_sn not like", value, "relatingRemoneySn");
            return (Criteria) this;
        }

        public Criteria andRelatingRemoneySnIn(List<String> values) {
            addCriterion("relating_remoney_sn in", values, "relatingRemoneySn");
            return (Criteria) this;
        }

        public Criteria andRelatingRemoneySnNotIn(List<String> values) {
            addCriterion("relating_remoney_sn not in", values, "relatingRemoneySn");
            return (Criteria) this;
        }

        public Criteria andRelatingRemoneySnBetween(String value1, String value2) {
            addCriterion("relating_remoney_sn between", value1, value2, "relatingRemoneySn");
            return (Criteria) this;
        }

        public Criteria andRelatingRemoneySnNotBetween(String value1, String value2) {
            addCriterion("relating_remoney_sn not between", value1, value2, "relatingRemoneySn");
            return (Criteria) this;
        }

        public Criteria andIsCustomerContractIsNull() {
            addCriterion("is_customer_contract is null");
            return (Criteria) this;
        }

        public Criteria andIsCustomerContractIsNotNull() {
            addCriterion("is_customer_contract is not null");
            return (Criteria) this;
        }

        public Criteria andIsCustomerContractEqualTo(Integer value) {
            addCriterion("is_customer_contract =", value, "isCustomerContract");
            return (Criteria) this;
        }

        public Criteria andIsCustomerContractNotEqualTo(Integer value) {
            addCriterion("is_customer_contract <>", value, "isCustomerContract");
            return (Criteria) this;
        }

        public Criteria andIsCustomerContractGreaterThan(Integer value) {
            addCriterion("is_customer_contract >", value, "isCustomerContract");
            return (Criteria) this;
        }

        public Criteria andIsCustomerContractGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_customer_contract >=", value, "isCustomerContract");
            return (Criteria) this;
        }

        public Criteria andIsCustomerContractLessThan(Integer value) {
            addCriterion("is_customer_contract <", value, "isCustomerContract");
            return (Criteria) this;
        }

        public Criteria andIsCustomerContractLessThanOrEqualTo(Integer value) {
            addCriterion("is_customer_contract <=", value, "isCustomerContract");
            return (Criteria) this;
        }

        public Criteria andIsCustomerContractIn(List<Integer> values) {
            addCriterion("is_customer_contract in", values, "isCustomerContract");
            return (Criteria) this;
        }

        public Criteria andIsCustomerContractNotIn(List<Integer> values) {
            addCriterion("is_customer_contract not in", values, "isCustomerContract");
            return (Criteria) this;
        }

        public Criteria andIsCustomerContractBetween(Integer value1, Integer value2) {
            addCriterion("is_customer_contract between", value1, value2, "isCustomerContract");
            return (Criteria) this;
        }

        public Criteria andIsCustomerContractNotBetween(Integer value1, Integer value2) {
            addCriterion("is_customer_contract not between", value1, value2, "isCustomerContract");
            return (Criteria) this;
        }

        public Criteria andUserNameIsNull() {
            addCriterion("user_name is null");
            return (Criteria) this;
        }

        public Criteria andUserNameIsNotNull() {
            addCriterion("user_name is not null");
            return (Criteria) this;
        }

        public Criteria andUserNameEqualTo(String value) {
            addCriterion("user_name =", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameNotEqualTo(String value) {
            addCriterion("user_name <>", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameGreaterThan(String value) {
            addCriterion("user_name >", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameGreaterThanOrEqualTo(String value) {
            addCriterion("user_name >=", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameLessThan(String value) {
            addCriterion("user_name <", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameLessThanOrEqualTo(String value) {
            addCriterion("user_name <=", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameLike(String value) {
            addCriterion("user_name like", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameNotLike(String value) {
            addCriterion("user_name not like", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameIn(List<String> values) {
            addCriterion("user_name in", values, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameNotIn(List<String> values) {
            addCriterion("user_name not in", values, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameBetween(String value1, String value2) {
            addCriterion("user_name between", value1, value2, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameNotBetween(String value1, String value2) {
            addCriterion("user_name not between", value1, value2, "userName");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeIsNull() {
            addCriterion("company_code is null");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeIsNotNull() {
            addCriterion("company_code is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeEqualTo(String value) {
            addCriterion("company_code =", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeNotEqualTo(String value) {
            addCriterion("company_code <>", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeGreaterThan(String value) {
            addCriterion("company_code >", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeGreaterThanOrEqualTo(String value) {
            addCriterion("company_code >=", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeLessThan(String value) {
            addCriterion("company_code <", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeLessThanOrEqualTo(String value) {
            addCriterion("company_code <=", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeLike(String value) {
            addCriterion("company_code like", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeNotLike(String value) {
            addCriterion("company_code not like", value, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeIn(List<String> values) {
            addCriterion("company_code in", values, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeNotIn(List<String> values) {
            addCriterion("company_code not in", values, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeBetween(String value1, String value2) {
            addCriterion("company_code between", value1, value2, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyCodeNotBetween(String value1, String value2) {
            addCriterion("company_code not between", value1, value2, "companyCode");
            return (Criteria) this;
        }

        public Criteria andCompanyNameIsNull() {
            addCriterion("company_name is null");
            return (Criteria) this;
        }

        public Criteria andCompanyNameIsNotNull() {
            addCriterion("company_name is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyNameEqualTo(String value) {
            addCriterion("company_name =", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotEqualTo(String value) {
            addCriterion("company_name <>", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameGreaterThan(String value) {
            addCriterion("company_name >", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameGreaterThanOrEqualTo(String value) {
            addCriterion("company_name >=", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameLessThan(String value) {
            addCriterion("company_name <", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameLessThanOrEqualTo(String value) {
            addCriterion("company_name <=", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameLike(String value) {
            addCriterion("company_name like", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotLike(String value) {
            addCriterion("company_name not like", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameIn(List<String> values) {
            addCriterion("company_name in", values, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotIn(List<String> values) {
            addCriterion("company_name not in", values, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameBetween(String value1, String value2) {
            addCriterion("company_name between", value1, value2, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotBetween(String value1, String value2) {
            addCriterion("company_name not between", value1, value2, "companyName");
            return (Criteria) this;
        }

        public Criteria andOrderStatusIsNull() {
            addCriterion("order_status is null");
            return (Criteria) this;
        }

        public Criteria andOrderStatusIsNotNull() {
            addCriterion("order_status is not null");
            return (Criteria) this;
        }

        public Criteria andOrderStatusEqualTo(Integer value) {
            addCriterion("order_status =", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotEqualTo(Integer value) {
            addCriterion("order_status <>", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusGreaterThan(Integer value) {
            addCriterion("order_status >", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("order_status >=", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusLessThan(Integer value) {
            addCriterion("order_status <", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusLessThanOrEqualTo(Integer value) {
            addCriterion("order_status <=", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusIn(List<Integer> values) {
            addCriterion("order_status in", values, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotIn(List<Integer> values) {
            addCriterion("order_status not in", values, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusBetween(Integer value1, Integer value2) {
            addCriterion("order_status between", value1, value2, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("order_status not between", value1, value2, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andPayStatusIsNull() {
            addCriterion("pay_status is null");
            return (Criteria) this;
        }

        public Criteria andPayStatusIsNotNull() {
            addCriterion("pay_status is not null");
            return (Criteria) this;
        }

        public Criteria andPayStatusEqualTo(Integer value) {
            addCriterion("pay_status =", value, "payStatus");
            return (Criteria) this;
        }

        public Criteria andPayStatusNotEqualTo(Integer value) {
            addCriterion("pay_status <>", value, "payStatus");
            return (Criteria) this;
        }

        public Criteria andPayStatusGreaterThan(Integer value) {
            addCriterion("pay_status >", value, "payStatus");
            return (Criteria) this;
        }

        public Criteria andPayStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("pay_status >=", value, "payStatus");
            return (Criteria) this;
        }

        public Criteria andPayStatusLessThan(Integer value) {
            addCriterion("pay_status <", value, "payStatus");
            return (Criteria) this;
        }

        public Criteria andPayStatusLessThanOrEqualTo(Integer value) {
            addCriterion("pay_status <=", value, "payStatus");
            return (Criteria) this;
        }

        public Criteria andPayStatusIn(List<Integer> values) {
            addCriterion("pay_status in", values, "payStatus");
            return (Criteria) this;
        }

        public Criteria andPayStatusNotIn(List<Integer> values) {
            addCriterion("pay_status not in", values, "payStatus");
            return (Criteria) this;
        }

        public Criteria andPayStatusBetween(Integer value1, Integer value2) {
            addCriterion("pay_status between", value1, value2, "payStatus");
            return (Criteria) this;
        }

        public Criteria andPayStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("pay_status not between", value1, value2, "payStatus");
            return (Criteria) this;
        }

        public Criteria andShipStatusIsNull() {
            addCriterion("ship_status is null");
            return (Criteria) this;
        }

        public Criteria andShipStatusIsNotNull() {
            addCriterion("ship_status is not null");
            return (Criteria) this;
        }

        public Criteria andShipStatusEqualTo(Integer value) {
            addCriterion("ship_status =", value, "shipStatus");
            return (Criteria) this;
        }

        public Criteria andShipStatusNotEqualTo(Integer value) {
            addCriterion("ship_status <>", value, "shipStatus");
            return (Criteria) this;
        }

        public Criteria andShipStatusGreaterThan(Integer value) {
            addCriterion("ship_status >", value, "shipStatus");
            return (Criteria) this;
        }

        public Criteria andShipStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("ship_status >=", value, "shipStatus");
            return (Criteria) this;
        }

        public Criteria andShipStatusLessThan(Integer value) {
            addCriterion("ship_status <", value, "shipStatus");
            return (Criteria) this;
        }

        public Criteria andShipStatusLessThanOrEqualTo(Integer value) {
            addCriterion("ship_status <=", value, "shipStatus");
            return (Criteria) this;
        }

        public Criteria andShipStatusIn(List<Integer> values) {
            addCriterion("ship_status in", values, "shipStatus");
            return (Criteria) this;
        }

        public Criteria andShipStatusNotIn(List<Integer> values) {
            addCriterion("ship_status not in", values, "shipStatus");
            return (Criteria) this;
        }

        public Criteria andShipStatusBetween(Integer value1, Integer value2) {
            addCriterion("ship_status between", value1, value2, "shipStatus");
            return (Criteria) this;
        }

        public Criteria andShipStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("ship_status not between", value1, value2, "shipStatus");
            return (Criteria) this;
        }

        public Criteria andUserConfirmStatusIsNull() {
            addCriterion("user_confirm_status is null");
            return (Criteria) this;
        }

        public Criteria andUserConfirmStatusIsNotNull() {
            addCriterion("user_confirm_status is not null");
            return (Criteria) this;
        }

        public Criteria andUserConfirmStatusEqualTo(Integer value) {
            addCriterion("user_confirm_status =", value, "userConfirmStatus");
            return (Criteria) this;
        }

        public Criteria andUserConfirmStatusNotEqualTo(Integer value) {
            addCriterion("user_confirm_status <>", value, "userConfirmStatus");
            return (Criteria) this;
        }

        public Criteria andUserConfirmStatusGreaterThan(Integer value) {
            addCriterion("user_confirm_status >", value, "userConfirmStatus");
            return (Criteria) this;
        }

        public Criteria andUserConfirmStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("user_confirm_status >=", value, "userConfirmStatus");
            return (Criteria) this;
        }

        public Criteria andUserConfirmStatusLessThan(Integer value) {
            addCriterion("user_confirm_status <", value, "userConfirmStatus");
            return (Criteria) this;
        }

        public Criteria andUserConfirmStatusLessThanOrEqualTo(Integer value) {
            addCriterion("user_confirm_status <=", value, "userConfirmStatus");
            return (Criteria) this;
        }

        public Criteria andUserConfirmStatusIn(List<Integer> values) {
            addCriterion("user_confirm_status in", values, "userConfirmStatus");
            return (Criteria) this;
        }

        public Criteria andUserConfirmStatusNotIn(List<Integer> values) {
            addCriterion("user_confirm_status not in", values, "userConfirmStatus");
            return (Criteria) this;
        }

        public Criteria andUserConfirmStatusBetween(Integer value1, Integer value2) {
            addCriterion("user_confirm_status between", value1, value2, "userConfirmStatus");
            return (Criteria) this;
        }

        public Criteria andUserConfirmStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("user_confirm_status not between", value1, value2, "userConfirmStatus");
            return (Criteria) this;
        }

        public Criteria andSpotStatusIsNull() {
            addCriterion("spot_status is null");
            return (Criteria) this;
        }

        public Criteria andSpotStatusIsNotNull() {
            addCriterion("spot_status is not null");
            return (Criteria) this;
        }

        public Criteria andSpotStatusEqualTo(Integer value) {
            addCriterion("spot_status =", value, "spotStatus");
            return (Criteria) this;
        }

        public Criteria andSpotStatusNotEqualTo(Integer value) {
            addCriterion("spot_status <>", value, "spotStatus");
            return (Criteria) this;
        }

        public Criteria andSpotStatusGreaterThan(Integer value) {
            addCriterion("spot_status >", value, "spotStatus");
            return (Criteria) this;
        }

        public Criteria andSpotStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("spot_status >=", value, "spotStatus");
            return (Criteria) this;
        }

        public Criteria andSpotStatusLessThan(Integer value) {
            addCriterion("spot_status <", value, "spotStatus");
            return (Criteria) this;
        }

        public Criteria andSpotStatusLessThanOrEqualTo(Integer value) {
            addCriterion("spot_status <=", value, "spotStatus");
            return (Criteria) this;
        }

        public Criteria andSpotStatusIn(List<Integer> values) {
            addCriterion("spot_status in", values, "spotStatus");
            return (Criteria) this;
        }

        public Criteria andSpotStatusNotIn(List<Integer> values) {
            addCriterion("spot_status not in", values, "spotStatus");
            return (Criteria) this;
        }

        public Criteria andSpotStatusBetween(Integer value1, Integer value2) {
            addCriterion("spot_status between", value1, value2, "spotStatus");
            return (Criteria) this;
        }

        public Criteria andSpotStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("spot_status not between", value1, value2, "spotStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusIsNull() {
            addCriterion("contract_status is null");
            return (Criteria) this;
        }

        public Criteria andContractStatusIsNotNull() {
            addCriterion("contract_status is not null");
            return (Criteria) this;
        }

        public Criteria andContractStatusEqualTo(Integer value) {
            addCriterion("contract_status =", value, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusNotEqualTo(Integer value) {
            addCriterion("contract_status <>", value, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusGreaterThan(Integer value) {
            addCriterion("contract_status >", value, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("contract_status >=", value, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusLessThan(Integer value) {
            addCriterion("contract_status <", value, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusLessThanOrEqualTo(Integer value) {
            addCriterion("contract_status <=", value, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusIn(List<Integer> values) {
            addCriterion("contract_status in", values, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusNotIn(List<Integer> values) {
            addCriterion("contract_status not in", values, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusBetween(Integer value1, Integer value2) {
            addCriterion("contract_status between", value1, value2, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andContractStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("contract_status not between", value1, value2, "contractStatus");
            return (Criteria) this;
        }

        public Criteria andOutOrderStatusIsNull() {
            addCriterion("out_order_status is null");
            return (Criteria) this;
        }

        public Criteria andOutOrderStatusIsNotNull() {
            addCriterion("out_order_status is not null");
            return (Criteria) this;
        }

        public Criteria andOutOrderStatusEqualTo(String value) {
            addCriterion("out_order_status =", value, "outOrderStatus");
            return (Criteria) this;
        }

        public Criteria andOutOrderStatusNotEqualTo(String value) {
            addCriterion("out_order_status <>", value, "outOrderStatus");
            return (Criteria) this;
        }

        public Criteria andOutOrderStatusGreaterThan(String value) {
            addCriterion("out_order_status >", value, "outOrderStatus");
            return (Criteria) this;
        }

        public Criteria andOutOrderStatusGreaterThanOrEqualTo(String value) {
            addCriterion("out_order_status >=", value, "outOrderStatus");
            return (Criteria) this;
        }

        public Criteria andOutOrderStatusLessThan(String value) {
            addCriterion("out_order_status <", value, "outOrderStatus");
            return (Criteria) this;
        }

        public Criteria andOutOrderStatusLessThanOrEqualTo(String value) {
            addCriterion("out_order_status <=", value, "outOrderStatus");
            return (Criteria) this;
        }

        public Criteria andOutOrderStatusLike(String value) {
            addCriterion("out_order_status like", value, "outOrderStatus");
            return (Criteria) this;
        }

        public Criteria andOutOrderStatusNotLike(String value) {
            addCriterion("out_order_status not like", value, "outOrderStatus");
            return (Criteria) this;
        }

        public Criteria andOutOrderStatusIn(List<String> values) {
            addCriterion("out_order_status in", values, "outOrderStatus");
            return (Criteria) this;
        }

        public Criteria andOutOrderStatusNotIn(List<String> values) {
            addCriterion("out_order_status not in", values, "outOrderStatus");
            return (Criteria) this;
        }

        public Criteria andOutOrderStatusBetween(String value1, String value2) {
            addCriterion("out_order_status between", value1, value2, "outOrderStatus");
            return (Criteria) this;
        }

        public Criteria andOutOrderStatusNotBetween(String value1, String value2) {
            addCriterion("out_order_status not between", value1, value2, "outOrderStatus");
            return (Criteria) this;
        }

        public Criteria andLockStatusIsNull() {
            addCriterion("lock_status is null");
            return (Criteria) this;
        }

        public Criteria andLockStatusIsNotNull() {
            addCriterion("lock_status is not null");
            return (Criteria) this;
        }

        public Criteria andLockStatusEqualTo(Integer value) {
            addCriterion("lock_status =", value, "lockStatus");
            return (Criteria) this;
        }

        public Criteria andLockStatusNotEqualTo(Integer value) {
            addCriterion("lock_status <>", value, "lockStatus");
            return (Criteria) this;
        }

        public Criteria andLockStatusGreaterThan(Integer value) {
            addCriterion("lock_status >", value, "lockStatus");
            return (Criteria) this;
        }

        public Criteria andLockStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("lock_status >=", value, "lockStatus");
            return (Criteria) this;
        }

        public Criteria andLockStatusLessThan(Integer value) {
            addCriterion("lock_status <", value, "lockStatus");
            return (Criteria) this;
        }

        public Criteria andLockStatusLessThanOrEqualTo(Integer value) {
            addCriterion("lock_status <=", value, "lockStatus");
            return (Criteria) this;
        }

        public Criteria andLockStatusIn(List<Integer> values) {
            addCriterion("lock_status in", values, "lockStatus");
            return (Criteria) this;
        }

        public Criteria andLockStatusNotIn(List<Integer> values) {
            addCriterion("lock_status not in", values, "lockStatus");
            return (Criteria) this;
        }

        public Criteria andLockStatusBetween(Integer value1, Integer value2) {
            addCriterion("lock_status between", value1, value2, "lockStatus");
            return (Criteria) this;
        }

        public Criteria andLockStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("lock_status not between", value1, value2, "lockStatus");
            return (Criteria) this;
        }

        public Criteria andQuestionStatusIsNull() {
            addCriterion("question_status is null");
            return (Criteria) this;
        }

        public Criteria andQuestionStatusIsNotNull() {
            addCriterion("question_status is not null");
            return (Criteria) this;
        }

        public Criteria andQuestionStatusEqualTo(Integer value) {
            addCriterion("question_status =", value, "questionStatus");
            return (Criteria) this;
        }

        public Criteria andQuestionStatusNotEqualTo(Integer value) {
            addCriterion("question_status <>", value, "questionStatus");
            return (Criteria) this;
        }

        public Criteria andQuestionStatusGreaterThan(Integer value) {
            addCriterion("question_status >", value, "questionStatus");
            return (Criteria) this;
        }

        public Criteria andQuestionStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("question_status >=", value, "questionStatus");
            return (Criteria) this;
        }

        public Criteria andQuestionStatusLessThan(Integer value) {
            addCriterion("question_status <", value, "questionStatus");
            return (Criteria) this;
        }

        public Criteria andQuestionStatusLessThanOrEqualTo(Integer value) {
            addCriterion("question_status <=", value, "questionStatus");
            return (Criteria) this;
        }

        public Criteria andQuestionStatusIn(List<Integer> values) {
            addCriterion("question_status in", values, "questionStatus");
            return (Criteria) this;
        }

        public Criteria andQuestionStatusNotIn(List<Integer> values) {
            addCriterion("question_status not in", values, "questionStatus");
            return (Criteria) this;
        }

        public Criteria andQuestionStatusBetween(Integer value1, Integer value2) {
            addCriterion("question_status between", value1, value2, "questionStatus");
            return (Criteria) this;
        }

        public Criteria andQuestionStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("question_status not between", value1, value2, "questionStatus");
            return (Criteria) this;
        }

        public Criteria andNoticeStatusIsNull() {
            addCriterion("notice_status is null");
            return (Criteria) this;
        }

        public Criteria andNoticeStatusIsNotNull() {
            addCriterion("notice_status is not null");
            return (Criteria) this;
        }

        public Criteria andNoticeStatusEqualTo(Integer value) {
            addCriterion("notice_status =", value, "noticeStatus");
            return (Criteria) this;
        }

        public Criteria andNoticeStatusNotEqualTo(Integer value) {
            addCriterion("notice_status <>", value, "noticeStatus");
            return (Criteria) this;
        }

        public Criteria andNoticeStatusGreaterThan(Integer value) {
            addCriterion("notice_status >", value, "noticeStatus");
            return (Criteria) this;
        }

        public Criteria andNoticeStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("notice_status >=", value, "noticeStatus");
            return (Criteria) this;
        }

        public Criteria andNoticeStatusLessThan(Integer value) {
            addCriterion("notice_status <", value, "noticeStatus");
            return (Criteria) this;
        }

        public Criteria andNoticeStatusLessThanOrEqualTo(Integer value) {
            addCriterion("notice_status <=", value, "noticeStatus");
            return (Criteria) this;
        }

        public Criteria andNoticeStatusIn(List<Integer> values) {
            addCriterion("notice_status in", values, "noticeStatus");
            return (Criteria) this;
        }

        public Criteria andNoticeStatusNotIn(List<Integer> values) {
            addCriterion("notice_status not in", values, "noticeStatus");
            return (Criteria) this;
        }

        public Criteria andNoticeStatusBetween(Integer value1, Integer value2) {
            addCriterion("notice_status between", value1, value2, "noticeStatus");
            return (Criteria) this;
        }

        public Criteria andNoticeStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("notice_status not between", value1, value2, "noticeStatus");
            return (Criteria) this;
        }

        public Criteria andSplitStatusIsNull() {
            addCriterion("split_status is null");
            return (Criteria) this;
        }

        public Criteria andSplitStatusIsNotNull() {
            addCriterion("split_status is not null");
            return (Criteria) this;
        }

        public Criteria andSplitStatusEqualTo(Integer value) {
            addCriterion("split_status =", value, "splitStatus");
            return (Criteria) this;
        }

        public Criteria andSplitStatusNotEqualTo(Integer value) {
            addCriterion("split_status <>", value, "splitStatus");
            return (Criteria) this;
        }

        public Criteria andSplitStatusGreaterThan(Integer value) {
            addCriterion("split_status >", value, "splitStatus");
            return (Criteria) this;
        }

        public Criteria andSplitStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("split_status >=", value, "splitStatus");
            return (Criteria) this;
        }

        public Criteria andSplitStatusLessThan(Integer value) {
            addCriterion("split_status <", value, "splitStatus");
            return (Criteria) this;
        }

        public Criteria andSplitStatusLessThanOrEqualTo(Integer value) {
            addCriterion("split_status <=", value, "splitStatus");
            return (Criteria) this;
        }

        public Criteria andSplitStatusIn(List<Integer> values) {
            addCriterion("split_status in", values, "splitStatus");
            return (Criteria) this;
        }

        public Criteria andSplitStatusNotIn(List<Integer> values) {
            addCriterion("split_status not in", values, "splitStatus");
            return (Criteria) this;
        }

        public Criteria andSplitStatusBetween(Integer value1, Integer value2) {
            addCriterion("split_status between", value1, value2, "splitStatus");
            return (Criteria) this;
        }

        public Criteria andSplitStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("split_status not between", value1, value2, "splitStatus");
            return (Criteria) this;
        }

        public Criteria andSplitTimeIsNull() {
            addCriterion("split_time is null");
            return (Criteria) this;
        }

        public Criteria andSplitTimeIsNotNull() {
            addCriterion("split_time is not null");
            return (Criteria) this;
        }

        public Criteria andSplitTimeEqualTo(Date value) {
            addCriterion("split_time =", value, "splitTime");
            return (Criteria) this;
        }

        public Criteria andSplitTimeNotEqualTo(Date value) {
            addCriterion("split_time <>", value, "splitTime");
            return (Criteria) this;
        }

        public Criteria andSplitTimeGreaterThan(Date value) {
            addCriterion("split_time >", value, "splitTime");
            return (Criteria) this;
        }

        public Criteria andSplitTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("split_time >=", value, "splitTime");
            return (Criteria) this;
        }

        public Criteria andSplitTimeLessThan(Date value) {
            addCriterion("split_time <", value, "splitTime");
            return (Criteria) this;
        }

        public Criteria andSplitTimeLessThanOrEqualTo(Date value) {
            addCriterion("split_time <=", value, "splitTime");
            return (Criteria) this;
        }

        public Criteria andSplitTimeIn(List<Date> values) {
            addCriterion("split_time in", values, "splitTime");
            return (Criteria) this;
        }

        public Criteria andSplitTimeNotIn(List<Date> values) {
            addCriterion("split_time not in", values, "splitTime");
            return (Criteria) this;
        }

        public Criteria andSplitTimeBetween(Date value1, Date value2) {
            addCriterion("split_time between", value1, value2, "splitTime");
            return (Criteria) this;
        }

        public Criteria andSplitTimeNotBetween(Date value1, Date value2) {
            addCriterion("split_time not between", value1, value2, "splitTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("create_time is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("create_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("create_time =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("create_time <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("create_time >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("create_time >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("create_time <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("create_time <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("create_time in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("create_time not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("create_time between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("create_time not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeIsNull() {
            addCriterion("confirm_time is null");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeIsNotNull() {
            addCriterion("confirm_time is not null");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeEqualTo(Date value) {
            addCriterion("confirm_time =", value, "confirmTime");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeNotEqualTo(Date value) {
            addCriterion("confirm_time <>", value, "confirmTime");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeGreaterThan(Date value) {
            addCriterion("confirm_time >", value, "confirmTime");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("confirm_time >=", value, "confirmTime");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeLessThan(Date value) {
            addCriterion("confirm_time <", value, "confirmTime");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeLessThanOrEqualTo(Date value) {
            addCriterion("confirm_time <=", value, "confirmTime");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeIn(List<Date> values) {
            addCriterion("confirm_time in", values, "confirmTime");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeNotIn(List<Date> values) {
            addCriterion("confirm_time not in", values, "confirmTime");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeBetween(Date value1, Date value2) {
            addCriterion("confirm_time between", value1, value2, "confirmTime");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeNotBetween(Date value1, Date value2) {
            addCriterion("confirm_time not between", value1, value2, "confirmTime");
            return (Criteria) this;
        }

        public Criteria andSigningTimeIsNull() {
            addCriterion("signing_time is null");
            return (Criteria) this;
        }

        public Criteria andSigningTimeIsNotNull() {
            addCriterion("signing_time is not null");
            return (Criteria) this;
        }

        public Criteria andSigningTimeEqualTo(Date value) {
            addCriterion("signing_time =", value, "signingTime");
            return (Criteria) this;
        }

        public Criteria andSigningTimeNotEqualTo(Date value) {
            addCriterion("signing_time <>", value, "signingTime");
            return (Criteria) this;
        }

        public Criteria andSigningTimeGreaterThan(Date value) {
            addCriterion("signing_time >", value, "signingTime");
            return (Criteria) this;
        }

        public Criteria andSigningTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("signing_time >=", value, "signingTime");
            return (Criteria) this;
        }

        public Criteria andSigningTimeLessThan(Date value) {
            addCriterion("signing_time <", value, "signingTime");
            return (Criteria) this;
        }

        public Criteria andSigningTimeLessThanOrEqualTo(Date value) {
            addCriterion("signing_time <=", value, "signingTime");
            return (Criteria) this;
        }

        public Criteria andSigningTimeIn(List<Date> values) {
            addCriterion("signing_time in", values, "signingTime");
            return (Criteria) this;
        }

        public Criteria andSigningTimeNotIn(List<Date> values) {
            addCriterion("signing_time not in", values, "signingTime");
            return (Criteria) this;
        }

        public Criteria andSigningTimeBetween(Date value1, Date value2) {
            addCriterion("signing_time between", value1, value2, "signingTime");
            return (Criteria) this;
        }

        public Criteria andSigningTimeNotBetween(Date value1, Date value2) {
            addCriterion("signing_time not between", value1, value2, "signingTime");
            return (Criteria) this;
        }

        public Criteria andConfirmShipTimeIsNull() {
            addCriterion("confirm_ship_time is null");
            return (Criteria) this;
        }

        public Criteria andConfirmShipTimeIsNotNull() {
            addCriterion("confirm_ship_time is not null");
            return (Criteria) this;
        }

        public Criteria andConfirmShipTimeEqualTo(Date value) {
            addCriterion("confirm_ship_time =", value, "confirmShipTime");
            return (Criteria) this;
        }

        public Criteria andConfirmShipTimeNotEqualTo(Date value) {
            addCriterion("confirm_ship_time <>", value, "confirmShipTime");
            return (Criteria) this;
        }

        public Criteria andConfirmShipTimeGreaterThan(Date value) {
            addCriterion("confirm_ship_time >", value, "confirmShipTime");
            return (Criteria) this;
        }

        public Criteria andConfirmShipTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("confirm_ship_time >=", value, "confirmShipTime");
            return (Criteria) this;
        }

        public Criteria andConfirmShipTimeLessThan(Date value) {
            addCriterion("confirm_ship_time <", value, "confirmShipTime");
            return (Criteria) this;
        }

        public Criteria andConfirmShipTimeLessThanOrEqualTo(Date value) {
            addCriterion("confirm_ship_time <=", value, "confirmShipTime");
            return (Criteria) this;
        }

        public Criteria andConfirmShipTimeIn(List<Date> values) {
            addCriterion("confirm_ship_time in", values, "confirmShipTime");
            return (Criteria) this;
        }

        public Criteria andConfirmShipTimeNotIn(List<Date> values) {
            addCriterion("confirm_ship_time not in", values, "confirmShipTime");
            return (Criteria) this;
        }

        public Criteria andConfirmShipTimeBetween(Date value1, Date value2) {
            addCriterion("confirm_ship_time between", value1, value2, "confirmShipTime");
            return (Criteria) this;
        }

        public Criteria andConfirmShipTimeNotBetween(Date value1, Date value2) {
            addCriterion("confirm_ship_time not between", value1, value2, "confirmShipTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeIsNull() {
            addCriterion("finish_time is null");
            return (Criteria) this;
        }

        public Criteria andFinishTimeIsNotNull() {
            addCriterion("finish_time is not null");
            return (Criteria) this;
        }

        public Criteria andFinishTimeEqualTo(Date value) {
            addCriterion("finish_time =", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeNotEqualTo(Date value) {
            addCriterion("finish_time <>", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeGreaterThan(Date value) {
            addCriterion("finish_time >", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("finish_time >=", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeLessThan(Date value) {
            addCriterion("finish_time <", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeLessThanOrEqualTo(Date value) {
            addCriterion("finish_time <=", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeIn(List<Date> values) {
            addCriterion("finish_time in", values, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeNotIn(List<Date> values) {
            addCriterion("finish_time not in", values, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeBetween(Date value1, Date value2) {
            addCriterion("finish_time between", value1, value2, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeNotBetween(Date value1, Date value2) {
            addCriterion("finish_time not between", value1, value2, "finishTime");
            return (Criteria) this;
        }

        public Criteria andClearTimeIsNull() {
            addCriterion("clear_time is null");
            return (Criteria) this;
        }

        public Criteria andClearTimeIsNotNull() {
            addCriterion("clear_time is not null");
            return (Criteria) this;
        }

        public Criteria andClearTimeEqualTo(Date value) {
            addCriterion("clear_time =", value, "clearTime");
            return (Criteria) this;
        }

        public Criteria andClearTimeNotEqualTo(Date value) {
            addCriterion("clear_time <>", value, "clearTime");
            return (Criteria) this;
        }

        public Criteria andClearTimeGreaterThan(Date value) {
            addCriterion("clear_time >", value, "clearTime");
            return (Criteria) this;
        }

        public Criteria andClearTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("clear_time >=", value, "clearTime");
            return (Criteria) this;
        }

        public Criteria andClearTimeLessThan(Date value) {
            addCriterion("clear_time <", value, "clearTime");
            return (Criteria) this;
        }

        public Criteria andClearTimeLessThanOrEqualTo(Date value) {
            addCriterion("clear_time <=", value, "clearTime");
            return (Criteria) this;
        }

        public Criteria andClearTimeIn(List<Date> values) {
            addCriterion("clear_time in", values, "clearTime");
            return (Criteria) this;
        }

        public Criteria andClearTimeNotIn(List<Date> values) {
            addCriterion("clear_time not in", values, "clearTime");
            return (Criteria) this;
        }

        public Criteria andClearTimeBetween(Date value1, Date value2) {
            addCriterion("clear_time between", value1, value2, "clearTime");
            return (Criteria) this;
        }

        public Criteria andClearTimeNotBetween(Date value1, Date value2) {
            addCriterion("clear_time not between", value1, value2, "clearTime");
            return (Criteria) this;
        }

        public Criteria andQuestionTimeIsNull() {
            addCriterion("question_time is null");
            return (Criteria) this;
        }

        public Criteria andQuestionTimeIsNotNull() {
            addCriterion("question_time is not null");
            return (Criteria) this;
        }

        public Criteria andQuestionTimeEqualTo(Date value) {
            addCriterion("question_time =", value, "questionTime");
            return (Criteria) this;
        }

        public Criteria andQuestionTimeNotEqualTo(Date value) {
            addCriterion("question_time <>", value, "questionTime");
            return (Criteria) this;
        }

        public Criteria andQuestionTimeGreaterThan(Date value) {
            addCriterion("question_time >", value, "questionTime");
            return (Criteria) this;
        }

        public Criteria andQuestionTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("question_time >=", value, "questionTime");
            return (Criteria) this;
        }

        public Criteria andQuestionTimeLessThan(Date value) {
            addCriterion("question_time <", value, "questionTime");
            return (Criteria) this;
        }

        public Criteria andQuestionTimeLessThanOrEqualTo(Date value) {
            addCriterion("question_time <=", value, "questionTime");
            return (Criteria) this;
        }

        public Criteria andQuestionTimeIn(List<Date> values) {
            addCriterion("question_time in", values, "questionTime");
            return (Criteria) this;
        }

        public Criteria andQuestionTimeNotIn(List<Date> values) {
            addCriterion("question_time not in", values, "questionTime");
            return (Criteria) this;
        }

        public Criteria andQuestionTimeBetween(Date value1, Date value2) {
            addCriterion("question_time between", value1, value2, "questionTime");
            return (Criteria) this;
        }

        public Criteria andQuestionTimeNotBetween(Date value1, Date value2) {
            addCriterion("question_time not between", value1, value2, "questionTime");
            return (Criteria) this;
        }

        public Criteria andLockTimeIsNull() {
            addCriterion("lock_time is null");
            return (Criteria) this;
        }

        public Criteria andLockTimeIsNotNull() {
            addCriterion("lock_time is not null");
            return (Criteria) this;
        }

        public Criteria andLockTimeEqualTo(Date value) {
            addCriterion("lock_time =", value, "lockTime");
            return (Criteria) this;
        }

        public Criteria andLockTimeNotEqualTo(Date value) {
            addCriterion("lock_time <>", value, "lockTime");
            return (Criteria) this;
        }

        public Criteria andLockTimeGreaterThan(Date value) {
            addCriterion("lock_time >", value, "lockTime");
            return (Criteria) this;
        }

        public Criteria andLockTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("lock_time >=", value, "lockTime");
            return (Criteria) this;
        }

        public Criteria andLockTimeLessThan(Date value) {
            addCriterion("lock_time <", value, "lockTime");
            return (Criteria) this;
        }

        public Criteria andLockTimeLessThanOrEqualTo(Date value) {
            addCriterion("lock_time <=", value, "lockTime");
            return (Criteria) this;
        }

        public Criteria andLockTimeIn(List<Date> values) {
            addCriterion("lock_time in", values, "lockTime");
            return (Criteria) this;
        }

        public Criteria andLockTimeNotIn(List<Date> values) {
            addCriterion("lock_time not in", values, "lockTime");
            return (Criteria) this;
        }

        public Criteria andLockTimeBetween(Date value1, Date value2) {
            addCriterion("lock_time between", value1, value2, "lockTime");
            return (Criteria) this;
        }

        public Criteria andLockTimeNotBetween(Date value1, Date value2) {
            addCriterion("lock_time not between", value1, value2, "lockTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("update_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("update_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("update_time =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("update_time <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("update_time >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("update_time >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("update_time <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("update_time <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("update_time in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("update_time not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("update_time between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("update_time not between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andNoticeTimeIsNull() {
            addCriterion("notice_time is null");
            return (Criteria) this;
        }

        public Criteria andNoticeTimeIsNotNull() {
            addCriterion("notice_time is not null");
            return (Criteria) this;
        }

        public Criteria andNoticeTimeEqualTo(Date value) {
            addCriterion("notice_time =", value, "noticeTime");
            return (Criteria) this;
        }

        public Criteria andNoticeTimeNotEqualTo(Date value) {
            addCriterion("notice_time <>", value, "noticeTime");
            return (Criteria) this;
        }

        public Criteria andNoticeTimeGreaterThan(Date value) {
            addCriterion("notice_time >", value, "noticeTime");
            return (Criteria) this;
        }

        public Criteria andNoticeTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("notice_time >=", value, "noticeTime");
            return (Criteria) this;
        }

        public Criteria andNoticeTimeLessThan(Date value) {
            addCriterion("notice_time <", value, "noticeTime");
            return (Criteria) this;
        }

        public Criteria andNoticeTimeLessThanOrEqualTo(Date value) {
            addCriterion("notice_time <=", value, "noticeTime");
            return (Criteria) this;
        }

        public Criteria andNoticeTimeIn(List<Date> values) {
            addCriterion("notice_time in", values, "noticeTime");
            return (Criteria) this;
        }

        public Criteria andNoticeTimeNotIn(List<Date> values) {
            addCriterion("notice_time not in", values, "noticeTime");
            return (Criteria) this;
        }

        public Criteria andNoticeTimeBetween(Date value1, Date value2) {
            addCriterion("notice_time between", value1, value2, "noticeTime");
            return (Criteria) this;
        }

        public Criteria andNoticeTimeNotBetween(Date value1, Date value2) {
            addCriterion("notice_time not between", value1, value2, "noticeTime");
            return (Criteria) this;
        }

        public Criteria andOutOrderSnIsNull() {
            addCriterion("out_order_sn is null");
            return (Criteria) this;
        }

        public Criteria andOutOrderSnIsNotNull() {
            addCriterion("out_order_sn is not null");
            return (Criteria) this;
        }

        public Criteria andOutOrderSnEqualTo(String value) {
            addCriterion("out_order_sn =", value, "outOrderSn");
            return (Criteria) this;
        }

        public Criteria andOutOrderSnNotEqualTo(String value) {
            addCriterion("out_order_sn <>", value, "outOrderSn");
            return (Criteria) this;
        }

        public Criteria andOutOrderSnGreaterThan(String value) {
            addCriterion("out_order_sn >", value, "outOrderSn");
            return (Criteria) this;
        }

        public Criteria andOutOrderSnGreaterThanOrEqualTo(String value) {
            addCriterion("out_order_sn >=", value, "outOrderSn");
            return (Criteria) this;
        }

        public Criteria andOutOrderSnLessThan(String value) {
            addCriterion("out_order_sn <", value, "outOrderSn");
            return (Criteria) this;
        }

        public Criteria andOutOrderSnLessThanOrEqualTo(String value) {
            addCriterion("out_order_sn <=", value, "outOrderSn");
            return (Criteria) this;
        }

        public Criteria andOutOrderSnLike(String value) {
            addCriterion("out_order_sn like", value, "outOrderSn");
            return (Criteria) this;
        }

        public Criteria andOutOrderSnNotLike(String value) {
            addCriterion("out_order_sn not like", value, "outOrderSn");
            return (Criteria) this;
        }

        public Criteria andOutOrderSnIn(List<String> values) {
            addCriterion("out_order_sn in", values, "outOrderSn");
            return (Criteria) this;
        }

        public Criteria andOutOrderSnNotIn(List<String> values) {
            addCriterion("out_order_sn not in", values, "outOrderSn");
            return (Criteria) this;
        }

        public Criteria andOutOrderSnBetween(String value1, String value2) {
            addCriterion("out_order_sn between", value1, value2, "outOrderSn");
            return (Criteria) this;
        }

        public Criteria andOutOrderSnNotBetween(String value1, String value2) {
            addCriterion("out_order_sn not between", value1, value2, "outOrderSn");
            return (Criteria) this;
        }

        public Criteria andOutContractSnIsNull() {
            addCriterion("out_contract_sn is null");
            return (Criteria) this;
        }

        public Criteria andOutContractSnIsNotNull() {
            addCriterion("out_contract_sn is not null");
            return (Criteria) this;
        }

        public Criteria andOutContractSnEqualTo(String value) {
            addCriterion("out_contract_sn =", value, "outContractSn");
            return (Criteria) this;
        }

        public Criteria andOutContractSnNotEqualTo(String value) {
            addCriterion("out_contract_sn <>", value, "outContractSn");
            return (Criteria) this;
        }

        public Criteria andOutContractSnGreaterThan(String value) {
            addCriterion("out_contract_sn >", value, "outContractSn");
            return (Criteria) this;
        }

        public Criteria andOutContractSnGreaterThanOrEqualTo(String value) {
            addCriterion("out_contract_sn >=", value, "outContractSn");
            return (Criteria) this;
        }

        public Criteria andOutContractSnLessThan(String value) {
            addCriterion("out_contract_sn <", value, "outContractSn");
            return (Criteria) this;
        }

        public Criteria andOutContractSnLessThanOrEqualTo(String value) {
            addCriterion("out_contract_sn <=", value, "outContractSn");
            return (Criteria) this;
        }

        public Criteria andOutContractSnLike(String value) {
            addCriterion("out_contract_sn like", value, "outContractSn");
            return (Criteria) this;
        }

        public Criteria andOutContractSnNotLike(String value) {
            addCriterion("out_contract_sn not like", value, "outContractSn");
            return (Criteria) this;
        }

        public Criteria andOutContractSnIn(List<String> values) {
            addCriterion("out_contract_sn in", values, "outContractSn");
            return (Criteria) this;
        }

        public Criteria andOutContractSnNotIn(List<String> values) {
            addCriterion("out_contract_sn not in", values, "outContractSn");
            return (Criteria) this;
        }

        public Criteria andOutContractSnBetween(String value1, String value2) {
            addCriterion("out_contract_sn between", value1, value2, "outContractSn");
            return (Criteria) this;
        }

        public Criteria andOutContractSnNotBetween(String value1, String value2) {
            addCriterion("out_contract_sn not between", value1, value2, "outContractSn");
            return (Criteria) this;
        }

        public Criteria andOutCustomerContractSnIsNull() {
            addCriterion("out_customer_contract_sn is null");
            return (Criteria) this;
        }

        public Criteria andOutCustomerContractSnIsNotNull() {
            addCriterion("out_customer_contract_sn is not null");
            return (Criteria) this;
        }

        public Criteria andOutCustomerContractSnEqualTo(String value) {
            addCriterion("out_customer_contract_sn =", value, "outCustomerContractSn");
            return (Criteria) this;
        }

        public Criteria andOutCustomerContractSnNotEqualTo(String value) {
            addCriterion("out_customer_contract_sn <>", value, "outCustomerContractSn");
            return (Criteria) this;
        }

        public Criteria andOutCustomerContractSnGreaterThan(String value) {
            addCriterion("out_customer_contract_sn >", value, "outCustomerContractSn");
            return (Criteria) this;
        }

        public Criteria andOutCustomerContractSnGreaterThanOrEqualTo(String value) {
            addCriterion("out_customer_contract_sn >=", value, "outCustomerContractSn");
            return (Criteria) this;
        }

        public Criteria andOutCustomerContractSnLessThan(String value) {
            addCriterion("out_customer_contract_sn <", value, "outCustomerContractSn");
            return (Criteria) this;
        }

        public Criteria andOutCustomerContractSnLessThanOrEqualTo(String value) {
            addCriterion("out_customer_contract_sn <=", value, "outCustomerContractSn");
            return (Criteria) this;
        }

        public Criteria andOutCustomerContractSnLike(String value) {
            addCriterion("out_customer_contract_sn like", value, "outCustomerContractSn");
            return (Criteria) this;
        }

        public Criteria andOutCustomerContractSnNotLike(String value) {
            addCriterion("out_customer_contract_sn not like", value, "outCustomerContractSn");
            return (Criteria) this;
        }

        public Criteria andOutCustomerContractSnIn(List<String> values) {
            addCriterion("out_customer_contract_sn in", values, "outCustomerContractSn");
            return (Criteria) this;
        }

        public Criteria andOutCustomerContractSnNotIn(List<String> values) {
            addCriterion("out_customer_contract_sn not in", values, "outCustomerContractSn");
            return (Criteria) this;
        }

        public Criteria andOutCustomerContractSnBetween(String value1, String value2) {
            addCriterion("out_customer_contract_sn between", value1, value2, "outCustomerContractSn");
            return (Criteria) this;
        }

        public Criteria andOutCustomerContractSnNotBetween(String value1, String value2) {
            addCriterion("out_customer_contract_sn not between", value1, value2, "outCustomerContractSn");
            return (Criteria) this;
        }

        public Criteria andOutProductClassifyCodeIsNull() {
            addCriterion("out_product_classify_code is null");
            return (Criteria) this;
        }

        public Criteria andOutProductClassifyCodeIsNotNull() {
            addCriterion("out_product_classify_code is not null");
            return (Criteria) this;
        }

        public Criteria andOutProductClassifyCodeEqualTo(String value) {
            addCriterion("out_product_classify_code =", value, "outProductClassifyCode");
            return (Criteria) this;
        }

        public Criteria andOutProductClassifyCodeNotEqualTo(String value) {
            addCriterion("out_product_classify_code <>", value, "outProductClassifyCode");
            return (Criteria) this;
        }

        public Criteria andOutProductClassifyCodeGreaterThan(String value) {
            addCriterion("out_product_classify_code >", value, "outProductClassifyCode");
            return (Criteria) this;
        }

        public Criteria andOutProductClassifyCodeGreaterThanOrEqualTo(String value) {
            addCriterion("out_product_classify_code >=", value, "outProductClassifyCode");
            return (Criteria) this;
        }

        public Criteria andOutProductClassifyCodeLessThan(String value) {
            addCriterion("out_product_classify_code <", value, "outProductClassifyCode");
            return (Criteria) this;
        }

        public Criteria andOutProductClassifyCodeLessThanOrEqualTo(String value) {
            addCriterion("out_product_classify_code <=", value, "outProductClassifyCode");
            return (Criteria) this;
        }

        public Criteria andOutProductClassifyCodeLike(String value) {
            addCriterion("out_product_classify_code like", value, "outProductClassifyCode");
            return (Criteria) this;
        }

        public Criteria andOutProductClassifyCodeNotLike(String value) {
            addCriterion("out_product_classify_code not like", value, "outProductClassifyCode");
            return (Criteria) this;
        }

        public Criteria andOutProductClassifyCodeIn(List<String> values) {
            addCriterion("out_product_classify_code in", values, "outProductClassifyCode");
            return (Criteria) this;
        }

        public Criteria andOutProductClassifyCodeNotIn(List<String> values) {
            addCriterion("out_product_classify_code not in", values, "outProductClassifyCode");
            return (Criteria) this;
        }

        public Criteria andOutProductClassifyCodeBetween(String value1, String value2) {
            addCriterion("out_product_classify_code between", value1, value2, "outProductClassifyCode");
            return (Criteria) this;
        }

        public Criteria andOutProductClassifyCodeNotBetween(String value1, String value2) {
            addCriterion("out_product_classify_code not between", value1, value2, "outProductClassifyCode");
            return (Criteria) this;
        }

        public Criteria andTotalDeliveryCycleIsNull() {
            addCriterion("total_delivery_cycle is null");
            return (Criteria) this;
        }

        public Criteria andTotalDeliveryCycleIsNotNull() {
            addCriterion("total_delivery_cycle is not null");
            return (Criteria) this;
        }

        public Criteria andTotalDeliveryCycleEqualTo(Integer value) {
            addCriterion("total_delivery_cycle =", value, "totalDeliveryCycle");
            return (Criteria) this;
        }

        public Criteria andTotalDeliveryCycleNotEqualTo(Integer value) {
            addCriterion("total_delivery_cycle <>", value, "totalDeliveryCycle");
            return (Criteria) this;
        }

        public Criteria andTotalDeliveryCycleGreaterThan(Integer value) {
            addCriterion("total_delivery_cycle >", value, "totalDeliveryCycle");
            return (Criteria) this;
        }

        public Criteria andTotalDeliveryCycleGreaterThanOrEqualTo(Integer value) {
            addCriterion("total_delivery_cycle >=", value, "totalDeliveryCycle");
            return (Criteria) this;
        }

        public Criteria andTotalDeliveryCycleLessThan(Integer value) {
            addCriterion("total_delivery_cycle <", value, "totalDeliveryCycle");
            return (Criteria) this;
        }

        public Criteria andTotalDeliveryCycleLessThanOrEqualTo(Integer value) {
            addCriterion("total_delivery_cycle <=", value, "totalDeliveryCycle");
            return (Criteria) this;
        }

        public Criteria andTotalDeliveryCycleIn(List<Integer> values) {
            addCriterion("total_delivery_cycle in", values, "totalDeliveryCycle");
            return (Criteria) this;
        }

        public Criteria andTotalDeliveryCycleNotIn(List<Integer> values) {
            addCriterion("total_delivery_cycle not in", values, "totalDeliveryCycle");
            return (Criteria) this;
        }

        public Criteria andTotalDeliveryCycleBetween(Integer value1, Integer value2) {
            addCriterion("total_delivery_cycle between", value1, value2, "totalDeliveryCycle");
            return (Criteria) this;
        }

        public Criteria andTotalDeliveryCycleNotBetween(Integer value1, Integer value2) {
            addCriterion("total_delivery_cycle not between", value1, value2, "totalDeliveryCycle");
            return (Criteria) this;
        }

        public Criteria andDeliveryCycleTimeIsNull() {
            addCriterion("delivery_cycle_time is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryCycleTimeIsNotNull() {
            addCriterion("delivery_cycle_time is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryCycleTimeEqualTo(Date value) {
            addCriterion("delivery_cycle_time =", value, "deliveryCycleTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryCycleTimeNotEqualTo(Date value) {
            addCriterion("delivery_cycle_time <>", value, "deliveryCycleTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryCycleTimeGreaterThan(Date value) {
            addCriterion("delivery_cycle_time >", value, "deliveryCycleTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryCycleTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("delivery_cycle_time >=", value, "deliveryCycleTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryCycleTimeLessThan(Date value) {
            addCriterion("delivery_cycle_time <", value, "deliveryCycleTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryCycleTimeLessThanOrEqualTo(Date value) {
            addCriterion("delivery_cycle_time <=", value, "deliveryCycleTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryCycleTimeIn(List<Date> values) {
            addCriterion("delivery_cycle_time in", values, "deliveryCycleTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryCycleTimeNotIn(List<Date> values) {
            addCriterion("delivery_cycle_time not in", values, "deliveryCycleTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryCycleTimeBetween(Date value1, Date value2) {
            addCriterion("delivery_cycle_time between", value1, value2, "deliveryCycleTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryCycleTimeNotBetween(Date value1, Date value2) {
            addCriterion("delivery_cycle_time not between", value1, value2, "deliveryCycleTime");
            return (Criteria) this;
        }

        public Criteria andPromotionIdsIsNull() {
            addCriterion("promotion_ids is null");
            return (Criteria) this;
        }

        public Criteria andPromotionIdsIsNotNull() {
            addCriterion("promotion_ids is not null");
            return (Criteria) this;
        }

        public Criteria andPromotionIdsEqualTo(String value) {
            addCriterion("promotion_ids =", value, "promotionIds");
            return (Criteria) this;
        }

        public Criteria andPromotionIdsNotEqualTo(String value) {
            addCriterion("promotion_ids <>", value, "promotionIds");
            return (Criteria) this;
        }

        public Criteria andPromotionIdsGreaterThan(String value) {
            addCriterion("promotion_ids >", value, "promotionIds");
            return (Criteria) this;
        }

        public Criteria andPromotionIdsGreaterThanOrEqualTo(String value) {
            addCriterion("promotion_ids >=", value, "promotionIds");
            return (Criteria) this;
        }

        public Criteria andPromotionIdsLessThan(String value) {
            addCriterion("promotion_ids <", value, "promotionIds");
            return (Criteria) this;
        }

        public Criteria andPromotionIdsLessThanOrEqualTo(String value) {
            addCriterion("promotion_ids <=", value, "promotionIds");
            return (Criteria) this;
        }

        public Criteria andPromotionIdsLike(String value) {
            addCriterion("promotion_ids like", value, "promotionIds");
            return (Criteria) this;
        }

        public Criteria andPromotionIdsNotLike(String value) {
            addCriterion("promotion_ids not like", value, "promotionIds");
            return (Criteria) this;
        }

        public Criteria andPromotionIdsIn(List<String> values) {
            addCriterion("promotion_ids in", values, "promotionIds");
            return (Criteria) this;
        }

        public Criteria andPromotionIdsNotIn(List<String> values) {
            addCriterion("promotion_ids not in", values, "promotionIds");
            return (Criteria) this;
        }

        public Criteria andPromotionIdsBetween(String value1, String value2) {
            addCriterion("promotion_ids between", value1, value2, "promotionIds");
            return (Criteria) this;
        }

        public Criteria andPromotionIdsNotBetween(String value1, String value2) {
            addCriterion("promotion_ids not between", value1, value2, "promotionIds");
            return (Criteria) this;
        }

        public Criteria andPromotionTitlesIsNull() {
            addCriterion("promotion_titles is null");
            return (Criteria) this;
        }

        public Criteria andPromotionTitlesIsNotNull() {
            addCriterion("promotion_titles is not null");
            return (Criteria) this;
        }

        public Criteria andPromotionTitlesEqualTo(String value) {
            addCriterion("promotion_titles =", value, "promotionTitles");
            return (Criteria) this;
        }

        public Criteria andPromotionTitlesNotEqualTo(String value) {
            addCriterion("promotion_titles <>", value, "promotionTitles");
            return (Criteria) this;
        }

        public Criteria andPromotionTitlesGreaterThan(String value) {
            addCriterion("promotion_titles >", value, "promotionTitles");
            return (Criteria) this;
        }

        public Criteria andPromotionTitlesGreaterThanOrEqualTo(String value) {
            addCriterion("promotion_titles >=", value, "promotionTitles");
            return (Criteria) this;
        }

        public Criteria andPromotionTitlesLessThan(String value) {
            addCriterion("promotion_titles <", value, "promotionTitles");
            return (Criteria) this;
        }

        public Criteria andPromotionTitlesLessThanOrEqualTo(String value) {
            addCriterion("promotion_titles <=", value, "promotionTitles");
            return (Criteria) this;
        }

        public Criteria andPromotionTitlesLike(String value) {
            addCriterion("promotion_titles like", value, "promotionTitles");
            return (Criteria) this;
        }

        public Criteria andPromotionTitlesNotLike(String value) {
            addCriterion("promotion_titles not like", value, "promotionTitles");
            return (Criteria) this;
        }

        public Criteria andPromotionTitlesIn(List<String> values) {
            addCriterion("promotion_titles in", values, "promotionTitles");
            return (Criteria) this;
        }

        public Criteria andPromotionTitlesNotIn(List<String> values) {
            addCriterion("promotion_titles not in", values, "promotionTitles");
            return (Criteria) this;
        }

        public Criteria andPromotionTitlesBetween(String value1, String value2) {
            addCriterion("promotion_titles between", value1, value2, "promotionTitles");
            return (Criteria) this;
        }

        public Criteria andPromotionTitlesNotBetween(String value1, String value2) {
            addCriterion("promotion_titles not between", value1, value2, "promotionTitles");
            return (Criteria) this;
        }

        public Criteria andRefererIsNull() {
            addCriterion("referer is null");
            return (Criteria) this;
        }

        public Criteria andRefererIsNotNull() {
            addCriterion("referer is not null");
            return (Criteria) this;
        }

        public Criteria andRefererEqualTo(String value) {
            addCriterion("referer =", value, "referer");
            return (Criteria) this;
        }

        public Criteria andRefererNotEqualTo(String value) {
            addCriterion("referer <>", value, "referer");
            return (Criteria) this;
        }

        public Criteria andRefererGreaterThan(String value) {
            addCriterion("referer >", value, "referer");
            return (Criteria) this;
        }

        public Criteria andRefererGreaterThanOrEqualTo(String value) {
            addCriterion("referer >=", value, "referer");
            return (Criteria) this;
        }

        public Criteria andRefererLessThan(String value) {
            addCriterion("referer <", value, "referer");
            return (Criteria) this;
        }

        public Criteria andRefererLessThanOrEqualTo(String value) {
            addCriterion("referer <=", value, "referer");
            return (Criteria) this;
        }

        public Criteria andRefererLike(String value) {
            addCriterion("referer like", value, "referer");
            return (Criteria) this;
        }

        public Criteria andRefererNotLike(String value) {
            addCriterion("referer not like", value, "referer");
            return (Criteria) this;
        }

        public Criteria andRefererIn(List<String> values) {
            addCriterion("referer in", values, "referer");
            return (Criteria) this;
        }

        public Criteria andRefererNotIn(List<String> values) {
            addCriterion("referer not in", values, "referer");
            return (Criteria) this;
        }

        public Criteria andRefererBetween(String value1, String value2) {
            addCriterion("referer between", value1, value2, "referer");
            return (Criteria) this;
        }

        public Criteria andRefererNotBetween(String value1, String value2) {
            addCriterion("referer not between", value1, value2, "referer");
            return (Criteria) this;
        }

        public Criteria andClearStatusIsNull() {
            addCriterion("clear_status is null");
            return (Criteria) this;
        }

        public Criteria andClearStatusIsNotNull() {
            addCriterion("clear_status is not null");
            return (Criteria) this;
        }

        public Criteria andClearStatusEqualTo(Integer value) {
            addCriterion("clear_status =", value, "clearStatus");
            return (Criteria) this;
        }

        public Criteria andClearStatusNotEqualTo(Integer value) {
            addCriterion("clear_status <>", value, "clearStatus");
            return (Criteria) this;
        }

        public Criteria andClearStatusGreaterThan(Integer value) {
            addCriterion("clear_status >", value, "clearStatus");
            return (Criteria) this;
        }

        public Criteria andClearStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("clear_status >=", value, "clearStatus");
            return (Criteria) this;
        }

        public Criteria andClearStatusLessThan(Integer value) {
            addCriterion("clear_status <", value, "clearStatus");
            return (Criteria) this;
        }

        public Criteria andClearStatusLessThanOrEqualTo(Integer value) {
            addCriterion("clear_status <=", value, "clearStatus");
            return (Criteria) this;
        }

        public Criteria andClearStatusIn(List<Integer> values) {
            addCriterion("clear_status in", values, "clearStatus");
            return (Criteria) this;
        }

        public Criteria andClearStatusNotIn(List<Integer> values) {
            addCriterion("clear_status not in", values, "clearStatus");
            return (Criteria) this;
        }

        public Criteria andClearStatusBetween(Integer value1, Integer value2) {
            addCriterion("clear_status between", value1, value2, "clearStatus");
            return (Criteria) this;
        }

        public Criteria andClearStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("clear_status not between", value1, value2, "clearStatus");
            return (Criteria) this;
        }

        public Criteria andLoadingBatchCodeIsNull() {
            addCriterion("loading_batch_code is null");
            return (Criteria) this;
        }

        public Criteria andLoadingBatchCodeIsNotNull() {
            addCriterion("loading_batch_code is not null");
            return (Criteria) this;
        }

        public Criteria andLoadingBatchCodeEqualTo(String value) {
            addCriterion("loading_batch_code =", value, "loadingBatchCode");
            return (Criteria) this;
        }

        public Criteria andLoadingBatchCodeNotEqualTo(String value) {
            addCriterion("loading_batch_code <>", value, "loadingBatchCode");
            return (Criteria) this;
        }

        public Criteria andLoadingBatchCodeGreaterThan(String value) {
            addCriterion("loading_batch_code >", value, "loadingBatchCode");
            return (Criteria) this;
        }

        public Criteria andLoadingBatchCodeGreaterThanOrEqualTo(String value) {
            addCriterion("loading_batch_code >=", value, "loadingBatchCode");
            return (Criteria) this;
        }

        public Criteria andLoadingBatchCodeLessThan(String value) {
            addCriterion("loading_batch_code <", value, "loadingBatchCode");
            return (Criteria) this;
        }

        public Criteria andLoadingBatchCodeLessThanOrEqualTo(String value) {
            addCriterion("loading_batch_code <=", value, "loadingBatchCode");
            return (Criteria) this;
        }

        public Criteria andLoadingBatchCodeLike(String value) {
            addCriterion("loading_batch_code like", value, "loadingBatchCode");
            return (Criteria) this;
        }

        public Criteria andLoadingBatchCodeNotLike(String value) {
            addCriterion("loading_batch_code not like", value, "loadingBatchCode");
            return (Criteria) this;
        }

        public Criteria andLoadingBatchCodeIn(List<String> values) {
            addCriterion("loading_batch_code in", values, "loadingBatchCode");
            return (Criteria) this;
        }

        public Criteria andLoadingBatchCodeNotIn(List<String> values) {
            addCriterion("loading_batch_code not in", values, "loadingBatchCode");
            return (Criteria) this;
        }

        public Criteria andLoadingBatchCodeBetween(String value1, String value2) {
            addCriterion("loading_batch_code between", value1, value2, "loadingBatchCode");
            return (Criteria) this;
        }

        public Criteria andLoadingBatchCodeNotBetween(String value1, String value2) {
            addCriterion("loading_batch_code not between", value1, value2, "loadingBatchCode");
            return (Criteria) this;
        }

        public Criteria andPayServicePriceIsNull() {
            addCriterion("pay_service_price is null");
            return (Criteria) this;
        }

        public Criteria andPayServicePriceIsNotNull() {
            addCriterion("pay_service_price is not null");
            return (Criteria) this;
        }

        public Criteria andPayServicePriceEqualTo(BigDecimal value) {
            addCriterion("pay_service_price =", value, "payServicePrice");
            return (Criteria) this;
        }

        public Criteria andPayServicePriceNotEqualTo(BigDecimal value) {
            addCriterion("pay_service_price <>", value, "payServicePrice");
            return (Criteria) this;
        }

        public Criteria andPayServicePriceGreaterThan(BigDecimal value) {
            addCriterion("pay_service_price >", value, "payServicePrice");
            return (Criteria) this;
        }

        public Criteria andPayServicePriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("pay_service_price >=", value, "payServicePrice");
            return (Criteria) this;
        }

        public Criteria andPayServicePriceLessThan(BigDecimal value) {
            addCriterion("pay_service_price <", value, "payServicePrice");
            return (Criteria) this;
        }

        public Criteria andPayServicePriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("pay_service_price <=", value, "payServicePrice");
            return (Criteria) this;
        }

        public Criteria andPayServicePriceIn(List<BigDecimal> values) {
            addCriterion("pay_service_price in", values, "payServicePrice");
            return (Criteria) this;
        }

        public Criteria andPayServicePriceNotIn(List<BigDecimal> values) {
            addCriterion("pay_service_price not in", values, "payServicePrice");
            return (Criteria) this;
        }

        public Criteria andPayServicePriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pay_service_price between", value1, value2, "payServicePrice");
            return (Criteria) this;
        }

        public Criteria andPayServicePriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pay_service_price not between", value1, value2, "payServicePrice");
            return (Criteria) this;
        }

        public Criteria andShippingTotalFeeIsNull() {
            addCriterion("shipping_total_fee is null");
            return (Criteria) this;
        }

        public Criteria andShippingTotalFeeIsNotNull() {
            addCriterion("shipping_total_fee is not null");
            return (Criteria) this;
        }

        public Criteria andShippingTotalFeeEqualTo(BigDecimal value) {
            addCriterion("shipping_total_fee =", value, "shippingTotalFee");
            return (Criteria) this;
        }

        public Criteria andShippingTotalFeeNotEqualTo(BigDecimal value) {
            addCriterion("shipping_total_fee <>", value, "shippingTotalFee");
            return (Criteria) this;
        }

        public Criteria andShippingTotalFeeGreaterThan(BigDecimal value) {
            addCriterion("shipping_total_fee >", value, "shippingTotalFee");
            return (Criteria) this;
        }

        public Criteria andShippingTotalFeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("shipping_total_fee >=", value, "shippingTotalFee");
            return (Criteria) this;
        }

        public Criteria andShippingTotalFeeLessThan(BigDecimal value) {
            addCriterion("shipping_total_fee <", value, "shippingTotalFee");
            return (Criteria) this;
        }

        public Criteria andShippingTotalFeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("shipping_total_fee <=", value, "shippingTotalFee");
            return (Criteria) this;
        }

        public Criteria andShippingTotalFeeIn(List<BigDecimal> values) {
            addCriterion("shipping_total_fee in", values, "shippingTotalFee");
            return (Criteria) this;
        }

        public Criteria andShippingTotalFeeNotIn(List<BigDecimal> values) {
            addCriterion("shipping_total_fee not in", values, "shippingTotalFee");
            return (Criteria) this;
        }

        public Criteria andShippingTotalFeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("shipping_total_fee between", value1, value2, "shippingTotalFee");
            return (Criteria) this;
        }

        public Criteria andShippingTotalFeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("shipping_total_fee not between", value1, value2, "shippingTotalFee");
            return (Criteria) this;
        }

        public Criteria andInsureTotalFeeIsNull() {
            addCriterion("insure_total_fee is null");
            return (Criteria) this;
        }

        public Criteria andInsureTotalFeeIsNotNull() {
            addCriterion("insure_total_fee is not null");
            return (Criteria) this;
        }

        public Criteria andInsureTotalFeeEqualTo(BigDecimal value) {
            addCriterion("insure_total_fee =", value, "insureTotalFee");
            return (Criteria) this;
        }

        public Criteria andInsureTotalFeeNotEqualTo(BigDecimal value) {
            addCriterion("insure_total_fee <>", value, "insureTotalFee");
            return (Criteria) this;
        }

        public Criteria andInsureTotalFeeGreaterThan(BigDecimal value) {
            addCriterion("insure_total_fee >", value, "insureTotalFee");
            return (Criteria) this;
        }

        public Criteria andInsureTotalFeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("insure_total_fee >=", value, "insureTotalFee");
            return (Criteria) this;
        }

        public Criteria andInsureTotalFeeLessThan(BigDecimal value) {
            addCriterion("insure_total_fee <", value, "insureTotalFee");
            return (Criteria) this;
        }

        public Criteria andInsureTotalFeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("insure_total_fee <=", value, "insureTotalFee");
            return (Criteria) this;
        }

        public Criteria andInsureTotalFeeIn(List<BigDecimal> values) {
            addCriterion("insure_total_fee in", values, "insureTotalFee");
            return (Criteria) this;
        }

        public Criteria andInsureTotalFeeNotIn(List<BigDecimal> values) {
            addCriterion("insure_total_fee not in", values, "insureTotalFee");
            return (Criteria) this;
        }

        public Criteria andInsureTotalFeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("insure_total_fee between", value1, value2, "insureTotalFee");
            return (Criteria) this;
        }

        public Criteria andInsureTotalFeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("insure_total_fee not between", value1, value2, "insureTotalFee");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeIsNull() {
            addCriterion("pay_total_fee is null");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeIsNotNull() {
            addCriterion("pay_total_fee is not null");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeEqualTo(BigDecimal value) {
            addCriterion("pay_total_fee =", value, "payTotalFee");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeNotEqualTo(BigDecimal value) {
            addCriterion("pay_total_fee <>", value, "payTotalFee");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeGreaterThan(BigDecimal value) {
            addCriterion("pay_total_fee >", value, "payTotalFee");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("pay_total_fee >=", value, "payTotalFee");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeLessThan(BigDecimal value) {
            addCriterion("pay_total_fee <", value, "payTotalFee");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("pay_total_fee <=", value, "payTotalFee");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeIn(List<BigDecimal> values) {
            addCriterion("pay_total_fee in", values, "payTotalFee");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeNotIn(List<BigDecimal> values) {
            addCriterion("pay_total_fee not in", values, "payTotalFee");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pay_total_fee between", value1, value2, "payTotalFee");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pay_total_fee not between", value1, value2, "payTotalFee");
            return (Criteria) this;
        }

        public Criteria andTotalPayableIsNull() {
            addCriterion("total_payable is null");
            return (Criteria) this;
        }

        public Criteria andTotalPayableIsNotNull() {
            addCriterion("total_payable is not null");
            return (Criteria) this;
        }

        public Criteria andTotalPayableEqualTo(BigDecimal value) {
            addCriterion("total_payable =", value, "totalPayable");
            return (Criteria) this;
        }

        public Criteria andTotalPayableNotEqualTo(BigDecimal value) {
            addCriterion("total_payable <>", value, "totalPayable");
            return (Criteria) this;
        }

        public Criteria andTotalPayableGreaterThan(BigDecimal value) {
            addCriterion("total_payable >", value, "totalPayable");
            return (Criteria) this;
        }

        public Criteria andTotalPayableGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("total_payable >=", value, "totalPayable");
            return (Criteria) this;
        }

        public Criteria andTotalPayableLessThan(BigDecimal value) {
            addCriterion("total_payable <", value, "totalPayable");
            return (Criteria) this;
        }

        public Criteria andTotalPayableLessThanOrEqualTo(BigDecimal value) {
            addCriterion("total_payable <=", value, "totalPayable");
            return (Criteria) this;
        }

        public Criteria andTotalPayableIn(List<BigDecimal> values) {
            addCriterion("total_payable in", values, "totalPayable");
            return (Criteria) this;
        }

        public Criteria andTotalPayableNotIn(List<BigDecimal> values) {
            addCriterion("total_payable not in", values, "totalPayable");
            return (Criteria) this;
        }

        public Criteria andTotalPayableBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("total_payable between", value1, value2, "totalPayable");
            return (Criteria) this;
        }

        public Criteria andTotalPayableNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("total_payable not between", value1, value2, "totalPayable");
            return (Criteria) this;
        }

        public Criteria andExtraServicesPriceIsNull() {
            addCriterion("extra_services_price is null");
            return (Criteria) this;
        }

        public Criteria andExtraServicesPriceIsNotNull() {
            addCriterion("extra_services_price is not null");
            return (Criteria) this;
        }

        public Criteria andExtraServicesPriceEqualTo(BigDecimal value) {
            addCriterion("extra_services_price =", value, "extraServicesPrice");
            return (Criteria) this;
        }

        public Criteria andExtraServicesPriceNotEqualTo(BigDecimal value) {
            addCriterion("extra_services_price <>", value, "extraServicesPrice");
            return (Criteria) this;
        }

        public Criteria andExtraServicesPriceGreaterThan(BigDecimal value) {
            addCriterion("extra_services_price >", value, "extraServicesPrice");
            return (Criteria) this;
        }

        public Criteria andExtraServicesPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("extra_services_price >=", value, "extraServicesPrice");
            return (Criteria) this;
        }

        public Criteria andExtraServicesPriceLessThan(BigDecimal value) {
            addCriterion("extra_services_price <", value, "extraServicesPrice");
            return (Criteria) this;
        }

        public Criteria andExtraServicesPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("extra_services_price <=", value, "extraServicesPrice");
            return (Criteria) this;
        }

        public Criteria andExtraServicesPriceIn(List<BigDecimal> values) {
            addCriterion("extra_services_price in", values, "extraServicesPrice");
            return (Criteria) this;
        }

        public Criteria andExtraServicesPriceNotIn(List<BigDecimal> values) {
            addCriterion("extra_services_price not in", values, "extraServicesPrice");
            return (Criteria) this;
        }

        public Criteria andExtraServicesPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("extra_services_price between", value1, value2, "extraServicesPrice");
            return (Criteria) this;
        }

        public Criteria andExtraServicesPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("extra_services_price not between", value1, value2, "extraServicesPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountIsNull() {
            addCriterion("goods_amount is null");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountIsNotNull() {
            addCriterion("goods_amount is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountEqualTo(BigDecimal value) {
            addCriterion("goods_amount =", value, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountNotEqualTo(BigDecimal value) {
            addCriterion("goods_amount <>", value, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountGreaterThan(BigDecimal value) {
            addCriterion("goods_amount >", value, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("goods_amount >=", value, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountLessThan(BigDecimal value) {
            addCriterion("goods_amount <", value, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("goods_amount <=", value, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountIn(List<BigDecimal> values) {
            addCriterion("goods_amount in", values, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountNotIn(List<BigDecimal> values) {
            addCriterion("goods_amount not in", values, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("goods_amount between", value1, value2, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("goods_amount not between", value1, value2, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andTotalFeeIsNull() {
            addCriterion("total_fee is null");
            return (Criteria) this;
        }

        public Criteria andTotalFeeIsNotNull() {
            addCriterion("total_fee is not null");
            return (Criteria) this;
        }

        public Criteria andTotalFeeEqualTo(BigDecimal value) {
            addCriterion("total_fee =", value, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeNotEqualTo(BigDecimal value) {
            addCriterion("total_fee <>", value, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeGreaterThan(BigDecimal value) {
            addCriterion("total_fee >", value, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("total_fee >=", value, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeLessThan(BigDecimal value) {
            addCriterion("total_fee <", value, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("total_fee <=", value, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeIn(List<BigDecimal> values) {
            addCriterion("total_fee in", values, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeNotIn(List<BigDecimal> values) {
            addCriterion("total_fee not in", values, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("total_fee between", value1, value2, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("total_fee not between", value1, value2, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalSettlementPriceIsNull() {
            addCriterion("total_settlement_price is null");
            return (Criteria) this;
        }

        public Criteria andTotalSettlementPriceIsNotNull() {
            addCriterion("total_settlement_price is not null");
            return (Criteria) this;
        }

        public Criteria andTotalSettlementPriceEqualTo(BigDecimal value) {
            addCriterion("total_settlement_price =", value, "totalSettlementPrice");
            return (Criteria) this;
        }

        public Criteria andTotalSettlementPriceNotEqualTo(BigDecimal value) {
            addCriterion("total_settlement_price <>", value, "totalSettlementPrice");
            return (Criteria) this;
        }

        public Criteria andTotalSettlementPriceGreaterThan(BigDecimal value) {
            addCriterion("total_settlement_price >", value, "totalSettlementPrice");
            return (Criteria) this;
        }

        public Criteria andTotalSettlementPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("total_settlement_price >=", value, "totalSettlementPrice");
            return (Criteria) this;
        }

        public Criteria andTotalSettlementPriceLessThan(BigDecimal value) {
            addCriterion("total_settlement_price <", value, "totalSettlementPrice");
            return (Criteria) this;
        }

        public Criteria andTotalSettlementPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("total_settlement_price <=", value, "totalSettlementPrice");
            return (Criteria) this;
        }

        public Criteria andTotalSettlementPriceIn(List<BigDecimal> values) {
            addCriterion("total_settlement_price in", values, "totalSettlementPrice");
            return (Criteria) this;
        }

        public Criteria andTotalSettlementPriceNotIn(List<BigDecimal> values) {
            addCriterion("total_settlement_price not in", values, "totalSettlementPrice");
            return (Criteria) this;
        }

        public Criteria andTotalSettlementPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("total_settlement_price between", value1, value2, "totalSettlementPrice");
            return (Criteria) this;
        }

        public Criteria andTotalSettlementPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("total_settlement_price not between", value1, value2, "totalSettlementPrice");
            return (Criteria) this;
        }

        public Criteria andSettlementDifferencePriceIsNull() {
            addCriterion("settlement_difference_price is null");
            return (Criteria) this;
        }

        public Criteria andSettlementDifferencePriceIsNotNull() {
            addCriterion("settlement_difference_price is not null");
            return (Criteria) this;
        }

        public Criteria andSettlementDifferencePriceEqualTo(BigDecimal value) {
            addCriterion("settlement_difference_price =", value, "settlementDifferencePrice");
            return (Criteria) this;
        }

        public Criteria andSettlementDifferencePriceNotEqualTo(BigDecimal value) {
            addCriterion("settlement_difference_price <>", value, "settlementDifferencePrice");
            return (Criteria) this;
        }

        public Criteria andSettlementDifferencePriceGreaterThan(BigDecimal value) {
            addCriterion("settlement_difference_price >", value, "settlementDifferencePrice");
            return (Criteria) this;
        }

        public Criteria andSettlementDifferencePriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("settlement_difference_price >=", value, "settlementDifferencePrice");
            return (Criteria) this;
        }

        public Criteria andSettlementDifferencePriceLessThan(BigDecimal value) {
            addCriterion("settlement_difference_price <", value, "settlementDifferencePrice");
            return (Criteria) this;
        }

        public Criteria andSettlementDifferencePriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("settlement_difference_price <=", value, "settlementDifferencePrice");
            return (Criteria) this;
        }

        public Criteria andSettlementDifferencePriceIn(List<BigDecimal> values) {
            addCriterion("settlement_difference_price in", values, "settlementDifferencePrice");
            return (Criteria) this;
        }

        public Criteria andSettlementDifferencePriceNotIn(List<BigDecimal> values) {
            addCriterion("settlement_difference_price not in", values, "settlementDifferencePrice");
            return (Criteria) this;
        }

        public Criteria andSettlementDifferencePriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("settlement_difference_price between", value1, value2, "settlementDifferencePrice");
            return (Criteria) this;
        }

        public Criteria andSettlementDifferencePriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("settlement_difference_price not between", value1, value2, "settlementDifferencePrice");
            return (Criteria) this;
        }

        public Criteria andMoneyPaidIsNull() {
            addCriterion("money_paid is null");
            return (Criteria) this;
        }

        public Criteria andMoneyPaidIsNotNull() {
            addCriterion("money_paid is not null");
            return (Criteria) this;
        }

        public Criteria andMoneyPaidEqualTo(BigDecimal value) {
            addCriterion("money_paid =", value, "moneyPaid");
            return (Criteria) this;
        }

        public Criteria andMoneyPaidNotEqualTo(BigDecimal value) {
            addCriterion("money_paid <>", value, "moneyPaid");
            return (Criteria) this;
        }

        public Criteria andMoneyPaidGreaterThan(BigDecimal value) {
            addCriterion("money_paid >", value, "moneyPaid");
            return (Criteria) this;
        }

        public Criteria andMoneyPaidGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("money_paid >=", value, "moneyPaid");
            return (Criteria) this;
        }

        public Criteria andMoneyPaidLessThan(BigDecimal value) {
            addCriterion("money_paid <", value, "moneyPaid");
            return (Criteria) this;
        }

        public Criteria andMoneyPaidLessThanOrEqualTo(BigDecimal value) {
            addCriterion("money_paid <=", value, "moneyPaid");
            return (Criteria) this;
        }

        public Criteria andMoneyPaidIn(List<BigDecimal> values) {
            addCriterion("money_paid in", values, "moneyPaid");
            return (Criteria) this;
        }

        public Criteria andMoneyPaidNotIn(List<BigDecimal> values) {
            addCriterion("money_paid not in", values, "moneyPaid");
            return (Criteria) this;
        }

        public Criteria andMoneyPaidBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("money_paid between", value1, value2, "moneyPaid");
            return (Criteria) this;
        }

        public Criteria andMoneyPaidNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("money_paid not between", value1, value2, "moneyPaid");
            return (Criteria) this;
        }

        public Criteria andSurplusIsNull() {
            addCriterion("surplus is null");
            return (Criteria) this;
        }

        public Criteria andSurplusIsNotNull() {
            addCriterion("surplus is not null");
            return (Criteria) this;
        }

        public Criteria andSurplusEqualTo(BigDecimal value) {
            addCriterion("surplus =", value, "surplus");
            return (Criteria) this;
        }

        public Criteria andSurplusNotEqualTo(BigDecimal value) {
            addCriterion("surplus <>", value, "surplus");
            return (Criteria) this;
        }

        public Criteria andSurplusGreaterThan(BigDecimal value) {
            addCriterion("surplus >", value, "surplus");
            return (Criteria) this;
        }

        public Criteria andSurplusGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("surplus >=", value, "surplus");
            return (Criteria) this;
        }

        public Criteria andSurplusLessThan(BigDecimal value) {
            addCriterion("surplus <", value, "surplus");
            return (Criteria) this;
        }

        public Criteria andSurplusLessThanOrEqualTo(BigDecimal value) {
            addCriterion("surplus <=", value, "surplus");
            return (Criteria) this;
        }

        public Criteria andSurplusIn(List<BigDecimal> values) {
            addCriterion("surplus in", values, "surplus");
            return (Criteria) this;
        }

        public Criteria andSurplusNotIn(List<BigDecimal> values) {
            addCriterion("surplus not in", values, "surplus");
            return (Criteria) this;
        }

        public Criteria andSurplusBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("surplus between", value1, value2, "surplus");
            return (Criteria) this;
        }

        public Criteria andSurplusNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("surplus not between", value1, value2, "surplus");
            return (Criteria) this;
        }

        public Criteria andBonusIdsIsNull() {
            addCriterion("bonus_ids is null");
            return (Criteria) this;
        }

        public Criteria andBonusIdsIsNotNull() {
            addCriterion("bonus_ids is not null");
            return (Criteria) this;
        }

        public Criteria andBonusIdsEqualTo(String value) {
            addCriterion("bonus_ids =", value, "bonusIds");
            return (Criteria) this;
        }

        public Criteria andBonusIdsNotEqualTo(String value) {
            addCriterion("bonus_ids <>", value, "bonusIds");
            return (Criteria) this;
        }

        public Criteria andBonusIdsGreaterThan(String value) {
            addCriterion("bonus_ids >", value, "bonusIds");
            return (Criteria) this;
        }

        public Criteria andBonusIdsGreaterThanOrEqualTo(String value) {
            addCriterion("bonus_ids >=", value, "bonusIds");
            return (Criteria) this;
        }

        public Criteria andBonusIdsLessThan(String value) {
            addCriterion("bonus_ids <", value, "bonusIds");
            return (Criteria) this;
        }

        public Criteria andBonusIdsLessThanOrEqualTo(String value) {
            addCriterion("bonus_ids <=", value, "bonusIds");
            return (Criteria) this;
        }

        public Criteria andBonusIdsLike(String value) {
            addCriterion("bonus_ids like", value, "bonusIds");
            return (Criteria) this;
        }

        public Criteria andBonusIdsNotLike(String value) {
            addCriterion("bonus_ids not like", value, "bonusIds");
            return (Criteria) this;
        }

        public Criteria andBonusIdsIn(List<String> values) {
            addCriterion("bonus_ids in", values, "bonusIds");
            return (Criteria) this;
        }

        public Criteria andBonusIdsNotIn(List<String> values) {
            addCriterion("bonus_ids not in", values, "bonusIds");
            return (Criteria) this;
        }

        public Criteria andBonusIdsBetween(String value1, String value2) {
            addCriterion("bonus_ids between", value1, value2, "bonusIds");
            return (Criteria) this;
        }

        public Criteria andBonusIdsNotBetween(String value1, String value2) {
            addCriterion("bonus_ids not between", value1, value2, "bonusIds");
            return (Criteria) this;
        }

        public Criteria andBonusPriceIsNull() {
            addCriterion("bonus_price is null");
            return (Criteria) this;
        }

        public Criteria andBonusPriceIsNotNull() {
            addCriterion("bonus_price is not null");
            return (Criteria) this;
        }

        public Criteria andBonusPriceEqualTo(BigDecimal value) {
            addCriterion("bonus_price =", value, "bonusPrice");
            return (Criteria) this;
        }

        public Criteria andBonusPriceNotEqualTo(BigDecimal value) {
            addCriterion("bonus_price <>", value, "bonusPrice");
            return (Criteria) this;
        }

        public Criteria andBonusPriceGreaterThan(BigDecimal value) {
            addCriterion("bonus_price >", value, "bonusPrice");
            return (Criteria) this;
        }

        public Criteria andBonusPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("bonus_price >=", value, "bonusPrice");
            return (Criteria) this;
        }

        public Criteria andBonusPriceLessThan(BigDecimal value) {
            addCriterion("bonus_price <", value, "bonusPrice");
            return (Criteria) this;
        }

        public Criteria andBonusPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("bonus_price <=", value, "bonusPrice");
            return (Criteria) this;
        }

        public Criteria andBonusPriceIn(List<BigDecimal> values) {
            addCriterion("bonus_price in", values, "bonusPrice");
            return (Criteria) this;
        }

        public Criteria andBonusPriceNotIn(List<BigDecimal> values) {
            addCriterion("bonus_price not in", values, "bonusPrice");
            return (Criteria) this;
        }

        public Criteria andBonusPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("bonus_price between", value1, value2, "bonusPrice");
            return (Criteria) this;
        }

        public Criteria andBonusPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("bonus_price not between", value1, value2, "bonusPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsQtyIsNull() {
            addCriterion("goods_qty is null");
            return (Criteria) this;
        }

        public Criteria andGoodsQtyIsNotNull() {
            addCriterion("goods_qty is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsQtyEqualTo(Integer value) {
            addCriterion("goods_qty =", value, "goodsQty");
            return (Criteria) this;
        }

        public Criteria andGoodsQtyNotEqualTo(Integer value) {
            addCriterion("goods_qty <>", value, "goodsQty");
            return (Criteria) this;
        }

        public Criteria andGoodsQtyGreaterThan(Integer value) {
            addCriterion("goods_qty >", value, "goodsQty");
            return (Criteria) this;
        }

        public Criteria andGoodsQtyGreaterThanOrEqualTo(Integer value) {
            addCriterion("goods_qty >=", value, "goodsQty");
            return (Criteria) this;
        }

        public Criteria andGoodsQtyLessThan(Integer value) {
            addCriterion("goods_qty <", value, "goodsQty");
            return (Criteria) this;
        }

        public Criteria andGoodsQtyLessThanOrEqualTo(Integer value) {
            addCriterion("goods_qty <=", value, "goodsQty");
            return (Criteria) this;
        }

        public Criteria andGoodsQtyIn(List<Integer> values) {
            addCriterion("goods_qty in", values, "goodsQty");
            return (Criteria) this;
        }

        public Criteria andGoodsQtyNotIn(List<Integer> values) {
            addCriterion("goods_qty not in", values, "goodsQty");
            return (Criteria) this;
        }

        public Criteria andGoodsQtyBetween(Integer value1, Integer value2) {
            addCriterion("goods_qty between", value1, value2, "goodsQty");
            return (Criteria) this;
        }

        public Criteria andGoodsQtyNotBetween(Integer value1, Integer value2) {
            addCriterion("goods_qty not between", value1, value2, "goodsQty");
            return (Criteria) this;
        }

        public Criteria andGoodsWeightIsNull() {
            addCriterion("goods_weight is null");
            return (Criteria) this;
        }

        public Criteria andGoodsWeightIsNotNull() {
            addCriterion("goods_weight is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsWeightEqualTo(BigDecimal value) {
            addCriterion("goods_weight =", value, "goodsWeight");
            return (Criteria) this;
        }

        public Criteria andGoodsWeightNotEqualTo(BigDecimal value) {
            addCriterion("goods_weight <>", value, "goodsWeight");
            return (Criteria) this;
        }

        public Criteria andGoodsWeightGreaterThan(BigDecimal value) {
            addCriterion("goods_weight >", value, "goodsWeight");
            return (Criteria) this;
        }

        public Criteria andGoodsWeightGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("goods_weight >=", value, "goodsWeight");
            return (Criteria) this;
        }

        public Criteria andGoodsWeightLessThan(BigDecimal value) {
            addCriterion("goods_weight <", value, "goodsWeight");
            return (Criteria) this;
        }

        public Criteria andGoodsWeightLessThanOrEqualTo(BigDecimal value) {
            addCriterion("goods_weight <=", value, "goodsWeight");
            return (Criteria) this;
        }

        public Criteria andGoodsWeightIn(List<BigDecimal> values) {
            addCriterion("goods_weight in", values, "goodsWeight");
            return (Criteria) this;
        }

        public Criteria andGoodsWeightNotIn(List<BigDecimal> values) {
            addCriterion("goods_weight not in", values, "goodsWeight");
            return (Criteria) this;
        }

        public Criteria andGoodsWeightBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("goods_weight between", value1, value2, "goodsWeight");
            return (Criteria) this;
        }

        public Criteria andGoodsWeightNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("goods_weight not between", value1, value2, "goodsWeight");
            return (Criteria) this;
        }

        public Criteria andClearGoodsWeightIsNull() {
            addCriterion("clear_goods_weight is null");
            return (Criteria) this;
        }

        public Criteria andClearGoodsWeightIsNotNull() {
            addCriterion("clear_goods_weight is not null");
            return (Criteria) this;
        }

        public Criteria andClearGoodsWeightEqualTo(BigDecimal value) {
            addCriterion("clear_goods_weight =", value, "clearGoodsWeight");
            return (Criteria) this;
        }

        public Criteria andClearGoodsWeightNotEqualTo(BigDecimal value) {
            addCriterion("clear_goods_weight <>", value, "clearGoodsWeight");
            return (Criteria) this;
        }

        public Criteria andClearGoodsWeightGreaterThan(BigDecimal value) {
            addCriterion("clear_goods_weight >", value, "clearGoodsWeight");
            return (Criteria) this;
        }

        public Criteria andClearGoodsWeightGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("clear_goods_weight >=", value, "clearGoodsWeight");
            return (Criteria) this;
        }

        public Criteria andClearGoodsWeightLessThan(BigDecimal value) {
            addCriterion("clear_goods_weight <", value, "clearGoodsWeight");
            return (Criteria) this;
        }

        public Criteria andClearGoodsWeightLessThanOrEqualTo(BigDecimal value) {
            addCriterion("clear_goods_weight <=", value, "clearGoodsWeight");
            return (Criteria) this;
        }

        public Criteria andClearGoodsWeightIn(List<BigDecimal> values) {
            addCriterion("clear_goods_weight in", values, "clearGoodsWeight");
            return (Criteria) this;
        }

        public Criteria andClearGoodsWeightNotIn(List<BigDecimal> values) {
            addCriterion("clear_goods_weight not in", values, "clearGoodsWeight");
            return (Criteria) this;
        }

        public Criteria andClearGoodsWeightBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("clear_goods_weight between", value1, value2, "clearGoodsWeight");
            return (Criteria) this;
        }

        public Criteria andClearGoodsWeightNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("clear_goods_weight not between", value1, value2, "clearGoodsWeight");
            return (Criteria) this;
        }

        public Criteria andDiscountIsNull() {
            addCriterion("discount is null");
            return (Criteria) this;
        }

        public Criteria andDiscountIsNotNull() {
            addCriterion("discount is not null");
            return (Criteria) this;
        }

        public Criteria andDiscountEqualTo(BigDecimal value) {
            addCriterion("discount =", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountNotEqualTo(BigDecimal value) {
            addCriterion("discount <>", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountGreaterThan(BigDecimal value) {
            addCriterion("discount >", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("discount >=", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountLessThan(BigDecimal value) {
            addCriterion("discount <", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("discount <=", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountIn(List<BigDecimal> values) {
            addCriterion("discount in", values, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountNotIn(List<BigDecimal> values) {
            addCriterion("discount not in", values, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discount between", value1, value2, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discount not between", value1, value2, "discount");
            return (Criteria) this;
        }

        public Criteria andIntegralIsNull() {
            addCriterion("integral is null");
            return (Criteria) this;
        }

        public Criteria andIntegralIsNotNull() {
            addCriterion("integral is not null");
            return (Criteria) this;
        }

        public Criteria andIntegralEqualTo(BigDecimal value) {
            addCriterion("integral =", value, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralNotEqualTo(BigDecimal value) {
            addCriterion("integral <>", value, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralGreaterThan(BigDecimal value) {
            addCriterion("integral >", value, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("integral >=", value, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralLessThan(BigDecimal value) {
            addCriterion("integral <", value, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralLessThanOrEqualTo(BigDecimal value) {
            addCriterion("integral <=", value, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralIn(List<BigDecimal> values) {
            addCriterion("integral in", values, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralNotIn(List<BigDecimal> values) {
            addCriterion("integral not in", values, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("integral between", value1, value2, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("integral not between", value1, value2, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyIsNull() {
            addCriterion("integral_money is null");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyIsNotNull() {
            addCriterion("integral_money is not null");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyEqualTo(BigDecimal value) {
            addCriterion("integral_money =", value, "integralMoney");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyNotEqualTo(BigDecimal value) {
            addCriterion("integral_money <>", value, "integralMoney");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyGreaterThan(BigDecimal value) {
            addCriterion("integral_money >", value, "integralMoney");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("integral_money >=", value, "integralMoney");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyLessThan(BigDecimal value) {
            addCriterion("integral_money <", value, "integralMoney");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("integral_money <=", value, "integralMoney");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyIn(List<BigDecimal> values) {
            addCriterion("integral_money in", values, "integralMoney");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyNotIn(List<BigDecimal> values) {
            addCriterion("integral_money not in", values, "integralMoney");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("integral_money between", value1, value2, "integralMoney");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("integral_money not between", value1, value2, "integralMoney");
            return (Criteria) this;
        }

        public Criteria andPostscriptIsNull() {
            addCriterion("postscript is null");
            return (Criteria) this;
        }

        public Criteria andPostscriptIsNotNull() {
            addCriterion("postscript is not null");
            return (Criteria) this;
        }

        public Criteria andPostscriptEqualTo(String value) {
            addCriterion("postscript =", value, "postscript");
            return (Criteria) this;
        }

        public Criteria andPostscriptNotEqualTo(String value) {
            addCriterion("postscript <>", value, "postscript");
            return (Criteria) this;
        }

        public Criteria andPostscriptGreaterThan(String value) {
            addCriterion("postscript >", value, "postscript");
            return (Criteria) this;
        }

        public Criteria andPostscriptGreaterThanOrEqualTo(String value) {
            addCriterion("postscript >=", value, "postscript");
            return (Criteria) this;
        }

        public Criteria andPostscriptLessThan(String value) {
            addCriterion("postscript <", value, "postscript");
            return (Criteria) this;
        }

        public Criteria andPostscriptLessThanOrEqualTo(String value) {
            addCriterion("postscript <=", value, "postscript");
            return (Criteria) this;
        }

        public Criteria andPostscriptLike(String value) {
            addCriterion("postscript like", value, "postscript");
            return (Criteria) this;
        }

        public Criteria andPostscriptNotLike(String value) {
            addCriterion("postscript not like", value, "postscript");
            return (Criteria) this;
        }

        public Criteria andPostscriptIn(List<String> values) {
            addCriterion("postscript in", values, "postscript");
            return (Criteria) this;
        }

        public Criteria andPostscriptNotIn(List<String> values) {
            addCriterion("postscript not in", values, "postscript");
            return (Criteria) this;
        }

        public Criteria andPostscriptBetween(String value1, String value2) {
            addCriterion("postscript between", value1, value2, "postscript");
            return (Criteria) this;
        }

        public Criteria andPostscriptNotBetween(String value1, String value2) {
            addCriterion("postscript not between", value1, value2, "postscript");
            return (Criteria) this;
        }

        public Criteria andToBuyerIsNull() {
            addCriterion("to_buyer is null");
            return (Criteria) this;
        }

        public Criteria andToBuyerIsNotNull() {
            addCriterion("to_buyer is not null");
            return (Criteria) this;
        }

        public Criteria andToBuyerEqualTo(String value) {
            addCriterion("to_buyer =", value, "toBuyer");
            return (Criteria) this;
        }

        public Criteria andToBuyerNotEqualTo(String value) {
            addCriterion("to_buyer <>", value, "toBuyer");
            return (Criteria) this;
        }

        public Criteria andToBuyerGreaterThan(String value) {
            addCriterion("to_buyer >", value, "toBuyer");
            return (Criteria) this;
        }

        public Criteria andToBuyerGreaterThanOrEqualTo(String value) {
            addCriterion("to_buyer >=", value, "toBuyer");
            return (Criteria) this;
        }

        public Criteria andToBuyerLessThan(String value) {
            addCriterion("to_buyer <", value, "toBuyer");
            return (Criteria) this;
        }

        public Criteria andToBuyerLessThanOrEqualTo(String value) {
            addCriterion("to_buyer <=", value, "toBuyer");
            return (Criteria) this;
        }

        public Criteria andToBuyerLike(String value) {
            addCriterion("to_buyer like", value, "toBuyer");
            return (Criteria) this;
        }

        public Criteria andToBuyerNotLike(String value) {
            addCriterion("to_buyer not like", value, "toBuyer");
            return (Criteria) this;
        }

        public Criteria andToBuyerIn(List<String> values) {
            addCriterion("to_buyer in", values, "toBuyer");
            return (Criteria) this;
        }

        public Criteria andToBuyerNotIn(List<String> values) {
            addCriterion("to_buyer not in", values, "toBuyer");
            return (Criteria) this;
        }

        public Criteria andToBuyerBetween(String value1, String value2) {
            addCriterion("to_buyer between", value1, value2, "toBuyer");
            return (Criteria) this;
        }

        public Criteria andToBuyerNotBetween(String value1, String value2) {
            addCriterion("to_buyer not between", value1, value2, "toBuyer");
            return (Criteria) this;
        }

        public Criteria andCancelCodeIsNull() {
            addCriterion("cancel_code is null");
            return (Criteria) this;
        }

        public Criteria andCancelCodeIsNotNull() {
            addCriterion("cancel_code is not null");
            return (Criteria) this;
        }

        public Criteria andCancelCodeEqualTo(String value) {
            addCriterion("cancel_code =", value, "cancelCode");
            return (Criteria) this;
        }

        public Criteria andCancelCodeNotEqualTo(String value) {
            addCriterion("cancel_code <>", value, "cancelCode");
            return (Criteria) this;
        }

        public Criteria andCancelCodeGreaterThan(String value) {
            addCriterion("cancel_code >", value, "cancelCode");
            return (Criteria) this;
        }

        public Criteria andCancelCodeGreaterThanOrEqualTo(String value) {
            addCriterion("cancel_code >=", value, "cancelCode");
            return (Criteria) this;
        }

        public Criteria andCancelCodeLessThan(String value) {
            addCriterion("cancel_code <", value, "cancelCode");
            return (Criteria) this;
        }

        public Criteria andCancelCodeLessThanOrEqualTo(String value) {
            addCriterion("cancel_code <=", value, "cancelCode");
            return (Criteria) this;
        }

        public Criteria andCancelCodeLike(String value) {
            addCriterion("cancel_code like", value, "cancelCode");
            return (Criteria) this;
        }

        public Criteria andCancelCodeNotLike(String value) {
            addCriterion("cancel_code not like", value, "cancelCode");
            return (Criteria) this;
        }

        public Criteria andCancelCodeIn(List<String> values) {
            addCriterion("cancel_code in", values, "cancelCode");
            return (Criteria) this;
        }

        public Criteria andCancelCodeNotIn(List<String> values) {
            addCriterion("cancel_code not in", values, "cancelCode");
            return (Criteria) this;
        }

        public Criteria andCancelCodeBetween(String value1, String value2) {
            addCriterion("cancel_code between", value1, value2, "cancelCode");
            return (Criteria) this;
        }

        public Criteria andCancelCodeNotBetween(String value1, String value2) {
            addCriterion("cancel_code not between", value1, value2, "cancelCode");
            return (Criteria) this;
        }

        public Criteria andCancelReasonIsNull() {
            addCriterion("cancel_reason is null");
            return (Criteria) this;
        }

        public Criteria andCancelReasonIsNotNull() {
            addCriterion("cancel_reason is not null");
            return (Criteria) this;
        }

        public Criteria andCancelReasonEqualTo(String value) {
            addCriterion("cancel_reason =", value, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonNotEqualTo(String value) {
            addCriterion("cancel_reason <>", value, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonGreaterThan(String value) {
            addCriterion("cancel_reason >", value, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonGreaterThanOrEqualTo(String value) {
            addCriterion("cancel_reason >=", value, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonLessThan(String value) {
            addCriterion("cancel_reason <", value, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonLessThanOrEqualTo(String value) {
            addCriterion("cancel_reason <=", value, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonLike(String value) {
            addCriterion("cancel_reason like", value, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonNotLike(String value) {
            addCriterion("cancel_reason not like", value, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonIn(List<String> values) {
            addCriterion("cancel_reason in", values, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonNotIn(List<String> values) {
            addCriterion("cancel_reason not in", values, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonBetween(String value1, String value2) {
            addCriterion("cancel_reason between", value1, value2, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonNotBetween(String value1, String value2) {
            addCriterion("cancel_reason not between", value1, value2, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andIsPushSystemIsNull() {
            addCriterion("is_push_system is null");
            return (Criteria) this;
        }

        public Criteria andIsPushSystemIsNotNull() {
            addCriterion("is_push_system is not null");
            return (Criteria) this;
        }

        public Criteria andIsPushSystemEqualTo(Integer value) {
            addCriterion("is_push_system =", value, "isPushSystem");
            return (Criteria) this;
        }

        public Criteria andIsPushSystemNotEqualTo(Integer value) {
            addCriterion("is_push_system <>", value, "isPushSystem");
            return (Criteria) this;
        }

        public Criteria andIsPushSystemGreaterThan(Integer value) {
            addCriterion("is_push_system >", value, "isPushSystem");
            return (Criteria) this;
        }

        public Criteria andIsPushSystemGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_push_system >=", value, "isPushSystem");
            return (Criteria) this;
        }

        public Criteria andIsPushSystemLessThan(Integer value) {
            addCriterion("is_push_system <", value, "isPushSystem");
            return (Criteria) this;
        }

        public Criteria andIsPushSystemLessThanOrEqualTo(Integer value) {
            addCriterion("is_push_system <=", value, "isPushSystem");
            return (Criteria) this;
        }

        public Criteria andIsPushSystemIn(List<Integer> values) {
            addCriterion("is_push_system in", values, "isPushSystem");
            return (Criteria) this;
        }

        public Criteria andIsPushSystemNotIn(List<Integer> values) {
            addCriterion("is_push_system not in", values, "isPushSystem");
            return (Criteria) this;
        }

        public Criteria andIsPushSystemBetween(Integer value1, Integer value2) {
            addCriterion("is_push_system between", value1, value2, "isPushSystem");
            return (Criteria) this;
        }

        public Criteria andIsPushSystemNotBetween(Integer value1, Integer value2) {
            addCriterion("is_push_system not between", value1, value2, "isPushSystem");
            return (Criteria) this;
        }

        public Criteria andStaffCodeIsNull() {
            addCriterion("staff_code is null");
            return (Criteria) this;
        }

        public Criteria andStaffCodeIsNotNull() {
            addCriterion("staff_code is not null");
            return (Criteria) this;
        }

        public Criteria andStaffCodeEqualTo(String value) {
            addCriterion("staff_code =", value, "staffCode");
            return (Criteria) this;
        }

        public Criteria andStaffCodeNotEqualTo(String value) {
            addCriterion("staff_code <>", value, "staffCode");
            return (Criteria) this;
        }

        public Criteria andStaffCodeGreaterThan(String value) {
            addCriterion("staff_code >", value, "staffCode");
            return (Criteria) this;
        }

        public Criteria andStaffCodeGreaterThanOrEqualTo(String value) {
            addCriterion("staff_code >=", value, "staffCode");
            return (Criteria) this;
        }

        public Criteria andStaffCodeLessThan(String value) {
            addCriterion("staff_code <", value, "staffCode");
            return (Criteria) this;
        }

        public Criteria andStaffCodeLessThanOrEqualTo(String value) {
            addCriterion("staff_code <=", value, "staffCode");
            return (Criteria) this;
        }

        public Criteria andStaffCodeLike(String value) {
            addCriterion("staff_code like", value, "staffCode");
            return (Criteria) this;
        }

        public Criteria andStaffCodeNotLike(String value) {
            addCriterion("staff_code not like", value, "staffCode");
            return (Criteria) this;
        }

        public Criteria andStaffCodeIn(List<String> values) {
            addCriterion("staff_code in", values, "staffCode");
            return (Criteria) this;
        }

        public Criteria andStaffCodeNotIn(List<String> values) {
            addCriterion("staff_code not in", values, "staffCode");
            return (Criteria) this;
        }

        public Criteria andStaffCodeBetween(String value1, String value2) {
            addCriterion("staff_code between", value1, value2, "staffCode");
            return (Criteria) this;
        }

        public Criteria andStaffCodeNotBetween(String value1, String value2) {
            addCriterion("staff_code not between", value1, value2, "staffCode");
            return (Criteria) this;
        }

        public Criteria andStaffNameIsNull() {
            addCriterion("staff_name is null");
            return (Criteria) this;
        }

        public Criteria andStaffNameIsNotNull() {
            addCriterion("staff_name is not null");
            return (Criteria) this;
        }

        public Criteria andStaffNameEqualTo(String value) {
            addCriterion("staff_name =", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameNotEqualTo(String value) {
            addCriterion("staff_name <>", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameGreaterThan(String value) {
            addCriterion("staff_name >", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameGreaterThanOrEqualTo(String value) {
            addCriterion("staff_name >=", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameLessThan(String value) {
            addCriterion("staff_name <", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameLessThanOrEqualTo(String value) {
            addCriterion("staff_name <=", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameLike(String value) {
            addCriterion("staff_name like", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameNotLike(String value) {
            addCriterion("staff_name not like", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameIn(List<String> values) {
            addCriterion("staff_name in", values, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameNotIn(List<String> values) {
            addCriterion("staff_name not in", values, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameBetween(String value1, String value2) {
            addCriterion("staff_name between", value1, value2, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameNotBetween(String value1, String value2) {
            addCriterion("staff_name not between", value1, value2, "staffName");
            return (Criteria) this;
        }

        public Criteria andSaleAreaCodeIsNull() {
            addCriterion("sale_area_code is null");
            return (Criteria) this;
        }

        public Criteria andSaleAreaCodeIsNotNull() {
            addCriterion("sale_area_code is not null");
            return (Criteria) this;
        }

        public Criteria andSaleAreaCodeEqualTo(String value) {
            addCriterion("sale_area_code =", value, "saleAreaCode");
            return (Criteria) this;
        }

        public Criteria andSaleAreaCodeNotEqualTo(String value) {
            addCriterion("sale_area_code <>", value, "saleAreaCode");
            return (Criteria) this;
        }

        public Criteria andSaleAreaCodeGreaterThan(String value) {
            addCriterion("sale_area_code >", value, "saleAreaCode");
            return (Criteria) this;
        }

        public Criteria andSaleAreaCodeGreaterThanOrEqualTo(String value) {
            addCriterion("sale_area_code >=", value, "saleAreaCode");
            return (Criteria) this;
        }

        public Criteria andSaleAreaCodeLessThan(String value) {
            addCriterion("sale_area_code <", value, "saleAreaCode");
            return (Criteria) this;
        }

        public Criteria andSaleAreaCodeLessThanOrEqualTo(String value) {
            addCriterion("sale_area_code <=", value, "saleAreaCode");
            return (Criteria) this;
        }

        public Criteria andSaleAreaCodeLike(String value) {
            addCriterion("sale_area_code like", value, "saleAreaCode");
            return (Criteria) this;
        }

        public Criteria andSaleAreaCodeNotLike(String value) {
            addCriterion("sale_area_code not like", value, "saleAreaCode");
            return (Criteria) this;
        }

        public Criteria andSaleAreaCodeIn(List<String> values) {
            addCriterion("sale_area_code in", values, "saleAreaCode");
            return (Criteria) this;
        }

        public Criteria andSaleAreaCodeNotIn(List<String> values) {
            addCriterion("sale_area_code not in", values, "saleAreaCode");
            return (Criteria) this;
        }

        public Criteria andSaleAreaCodeBetween(String value1, String value2) {
            addCriterion("sale_area_code between", value1, value2, "saleAreaCode");
            return (Criteria) this;
        }

        public Criteria andSaleAreaCodeNotBetween(String value1, String value2) {
            addCriterion("sale_area_code not between", value1, value2, "saleAreaCode");
            return (Criteria) this;
        }

        public Criteria andSaleAreaNameIsNull() {
            addCriterion("sale_area_name is null");
            return (Criteria) this;
        }

        public Criteria andSaleAreaNameIsNotNull() {
            addCriterion("sale_area_name is not null");
            return (Criteria) this;
        }

        public Criteria andSaleAreaNameEqualTo(String value) {
            addCriterion("sale_area_name =", value, "saleAreaName");
            return (Criteria) this;
        }

        public Criteria andSaleAreaNameNotEqualTo(String value) {
            addCriterion("sale_area_name <>", value, "saleAreaName");
            return (Criteria) this;
        }

        public Criteria andSaleAreaNameGreaterThan(String value) {
            addCriterion("sale_area_name >", value, "saleAreaName");
            return (Criteria) this;
        }

        public Criteria andSaleAreaNameGreaterThanOrEqualTo(String value) {
            addCriterion("sale_area_name >=", value, "saleAreaName");
            return (Criteria) this;
        }

        public Criteria andSaleAreaNameLessThan(String value) {
            addCriterion("sale_area_name <", value, "saleAreaName");
            return (Criteria) this;
        }

        public Criteria andSaleAreaNameLessThanOrEqualTo(String value) {
            addCriterion("sale_area_name <=", value, "saleAreaName");
            return (Criteria) this;
        }

        public Criteria andSaleAreaNameLike(String value) {
            addCriterion("sale_area_name like", value, "saleAreaName");
            return (Criteria) this;
        }

        public Criteria andSaleAreaNameNotLike(String value) {
            addCriterion("sale_area_name not like", value, "saleAreaName");
            return (Criteria) this;
        }

        public Criteria andSaleAreaNameIn(List<String> values) {
            addCriterion("sale_area_name in", values, "saleAreaName");
            return (Criteria) this;
        }

        public Criteria andSaleAreaNameNotIn(List<String> values) {
            addCriterion("sale_area_name not in", values, "saleAreaName");
            return (Criteria) this;
        }

        public Criteria andSaleAreaNameBetween(String value1, String value2) {
            addCriterion("sale_area_name between", value1, value2, "saleAreaName");
            return (Criteria) this;
        }

        public Criteria andSaleAreaNameNotBetween(String value1, String value2) {
            addCriterion("sale_area_name not between", value1, value2, "saleAreaName");
            return (Criteria) this;
        }

        public Criteria andSaleGroupCodeIsNull() {
            addCriterion("sale_group_code is null");
            return (Criteria) this;
        }

        public Criteria andSaleGroupCodeIsNotNull() {
            addCriterion("sale_group_code is not null");
            return (Criteria) this;
        }

        public Criteria andSaleGroupCodeEqualTo(String value) {
            addCriterion("sale_group_code =", value, "saleGroupCode");
            return (Criteria) this;
        }

        public Criteria andSaleGroupCodeNotEqualTo(String value) {
            addCriterion("sale_group_code <>", value, "saleGroupCode");
            return (Criteria) this;
        }

        public Criteria andSaleGroupCodeGreaterThan(String value) {
            addCriterion("sale_group_code >", value, "saleGroupCode");
            return (Criteria) this;
        }

        public Criteria andSaleGroupCodeGreaterThanOrEqualTo(String value) {
            addCriterion("sale_group_code >=", value, "saleGroupCode");
            return (Criteria) this;
        }

        public Criteria andSaleGroupCodeLessThan(String value) {
            addCriterion("sale_group_code <", value, "saleGroupCode");
            return (Criteria) this;
        }

        public Criteria andSaleGroupCodeLessThanOrEqualTo(String value) {
            addCriterion("sale_group_code <=", value, "saleGroupCode");
            return (Criteria) this;
        }

        public Criteria andSaleGroupCodeLike(String value) {
            addCriterion("sale_group_code like", value, "saleGroupCode");
            return (Criteria) this;
        }

        public Criteria andSaleGroupCodeNotLike(String value) {
            addCriterion("sale_group_code not like", value, "saleGroupCode");
            return (Criteria) this;
        }

        public Criteria andSaleGroupCodeIn(List<String> values) {
            addCriterion("sale_group_code in", values, "saleGroupCode");
            return (Criteria) this;
        }

        public Criteria andSaleGroupCodeNotIn(List<String> values) {
            addCriterion("sale_group_code not in", values, "saleGroupCode");
            return (Criteria) this;
        }

        public Criteria andSaleGroupCodeBetween(String value1, String value2) {
            addCriterion("sale_group_code between", value1, value2, "saleGroupCode");
            return (Criteria) this;
        }

        public Criteria andSaleGroupCodeNotBetween(String value1, String value2) {
            addCriterion("sale_group_code not between", value1, value2, "saleGroupCode");
            return (Criteria) this;
        }

        public Criteria andSaleGroupNameIsNull() {
            addCriterion("sale_group_name is null");
            return (Criteria) this;
        }

        public Criteria andSaleGroupNameIsNotNull() {
            addCriterion("sale_group_name is not null");
            return (Criteria) this;
        }

        public Criteria andSaleGroupNameEqualTo(String value) {
            addCriterion("sale_group_name =", value, "saleGroupName");
            return (Criteria) this;
        }

        public Criteria andSaleGroupNameNotEqualTo(String value) {
            addCriterion("sale_group_name <>", value, "saleGroupName");
            return (Criteria) this;
        }

        public Criteria andSaleGroupNameGreaterThan(String value) {
            addCriterion("sale_group_name >", value, "saleGroupName");
            return (Criteria) this;
        }

        public Criteria andSaleGroupNameGreaterThanOrEqualTo(String value) {
            addCriterion("sale_group_name >=", value, "saleGroupName");
            return (Criteria) this;
        }

        public Criteria andSaleGroupNameLessThan(String value) {
            addCriterion("sale_group_name <", value, "saleGroupName");
            return (Criteria) this;
        }

        public Criteria andSaleGroupNameLessThanOrEqualTo(String value) {
            addCriterion("sale_group_name <=", value, "saleGroupName");
            return (Criteria) this;
        }

        public Criteria andSaleGroupNameLike(String value) {
            addCriterion("sale_group_name like", value, "saleGroupName");
            return (Criteria) this;
        }

        public Criteria andSaleGroupNameNotLike(String value) {
            addCriterion("sale_group_name not like", value, "saleGroupName");
            return (Criteria) this;
        }

        public Criteria andSaleGroupNameIn(List<String> values) {
            addCriterion("sale_group_name in", values, "saleGroupName");
            return (Criteria) this;
        }

        public Criteria andSaleGroupNameNotIn(List<String> values) {
            addCriterion("sale_group_name not in", values, "saleGroupName");
            return (Criteria) this;
        }

        public Criteria andSaleGroupNameBetween(String value1, String value2) {
            addCriterion("sale_group_name between", value1, value2, "saleGroupName");
            return (Criteria) this;
        }

        public Criteria andSaleGroupNameNotBetween(String value1, String value2) {
            addCriterion("sale_group_name not between", value1, value2, "saleGroupName");
            return (Criteria) this;
        }

        public Criteria andSourceIsNull() {
            addCriterion("source is null");
            return (Criteria) this;
        }

        public Criteria andSourceIsNotNull() {
            addCriterion("source is not null");
            return (Criteria) this;
        }

        public Criteria andSourceEqualTo(Integer value) {
            addCriterion("source =", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotEqualTo(Integer value) {
            addCriterion("source <>", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceGreaterThan(Integer value) {
            addCriterion("source >", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceGreaterThanOrEqualTo(Integer value) {
            addCriterion("source >=", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLessThan(Integer value) {
            addCriterion("source <", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLessThanOrEqualTo(Integer value) {
            addCriterion("source <=", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceIn(List<Integer> values) {
            addCriterion("source in", values, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotIn(List<Integer> values) {
            addCriterion("source not in", values, "source");
            return (Criteria) this;
        }

        public Criteria andSourceBetween(Integer value1, Integer value2) {
            addCriterion("source between", value1, value2, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotBetween(Integer value1, Integer value2) {
            addCriterion("source not between", value1, value2, "source");
            return (Criteria) this;
        }

        public Criteria andIsPickUpIsNull() {
            addCriterion("is_pick_up is null");
            return (Criteria) this;
        }

        public Criteria andIsPickUpIsNotNull() {
            addCriterion("is_pick_up is not null");
            return (Criteria) this;
        }

        public Criteria andIsPickUpEqualTo(Integer value) {
            addCriterion("is_pick_up =", value, "isPickUp");
            return (Criteria) this;
        }

        public Criteria andIsPickUpNotEqualTo(Integer value) {
            addCriterion("is_pick_up <>", value, "isPickUp");
            return (Criteria) this;
        }

        public Criteria andIsPickUpGreaterThan(Integer value) {
            addCriterion("is_pick_up >", value, "isPickUp");
            return (Criteria) this;
        }

        public Criteria andIsPickUpGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_pick_up >=", value, "isPickUp");
            return (Criteria) this;
        }

        public Criteria andIsPickUpLessThan(Integer value) {
            addCriterion("is_pick_up <", value, "isPickUp");
            return (Criteria) this;
        }

        public Criteria andIsPickUpLessThanOrEqualTo(Integer value) {
            addCriterion("is_pick_up <=", value, "isPickUp");
            return (Criteria) this;
        }

        public Criteria andIsPickUpIn(List<Integer> values) {
            addCriterion("is_pick_up in", values, "isPickUp");
            return (Criteria) this;
        }

        public Criteria andIsPickUpNotIn(List<Integer> values) {
            addCriterion("is_pick_up not in", values, "isPickUp");
            return (Criteria) this;
        }

        public Criteria andIsPickUpBetween(Integer value1, Integer value2) {
            addCriterion("is_pick_up between", value1, value2, "isPickUp");
            return (Criteria) this;
        }

        public Criteria andIsPickUpNotBetween(Integer value1, Integer value2) {
            addCriterion("is_pick_up not between", value1, value2, "isPickUp");
            return (Criteria) this;
        }

        public Criteria andPreeOccupyIsNull() {
            addCriterion("pree_occupy is null");
            return (Criteria) this;
        }

        public Criteria andPreeOccupyIsNotNull() {
            addCriterion("pree_occupy is not null");
            return (Criteria) this;
        }

        public Criteria andPreeOccupyEqualTo(Integer value) {
            addCriterion("pree_occupy =", value, "preeOccupy");
            return (Criteria) this;
        }

        public Criteria andPreeOccupyNotEqualTo(Integer value) {
            addCriterion("pree_occupy <>", value, "preeOccupy");
            return (Criteria) this;
        }

        public Criteria andPreeOccupyGreaterThan(Integer value) {
            addCriterion("pree_occupy >", value, "preeOccupy");
            return (Criteria) this;
        }

        public Criteria andPreeOccupyGreaterThanOrEqualTo(Integer value) {
            addCriterion("pree_occupy >=", value, "preeOccupy");
            return (Criteria) this;
        }

        public Criteria andPreeOccupyLessThan(Integer value) {
            addCriterion("pree_occupy <", value, "preeOccupy");
            return (Criteria) this;
        }

        public Criteria andPreeOccupyLessThanOrEqualTo(Integer value) {
            addCriterion("pree_occupy <=", value, "preeOccupy");
            return (Criteria) this;
        }

        public Criteria andPreeOccupyIn(List<Integer> values) {
            addCriterion("pree_occupy in", values, "preeOccupy");
            return (Criteria) this;
        }

        public Criteria andPreeOccupyNotIn(List<Integer> values) {
            addCriterion("pree_occupy not in", values, "preeOccupy");
            return (Criteria) this;
        }

        public Criteria andPreeOccupyBetween(Integer value1, Integer value2) {
            addCriterion("pree_occupy between", value1, value2, "preeOccupy");
            return (Criteria) this;
        }

        public Criteria andPreeOccupyNotBetween(Integer value1, Integer value2) {
            addCriterion("pree_occupy not between", value1, value2, "preeOccupy");
            return (Criteria) this;
        }

        public Criteria andUnitTitleIsNull() {
            addCriterion("unit_title is null");
            return (Criteria) this;
        }

        public Criteria andUnitTitleIsNotNull() {
            addCriterion("unit_title is not null");
            return (Criteria) this;
        }

        public Criteria andUnitTitleEqualTo(String value) {
            addCriterion("unit_title =", value, "unitTitle");
            return (Criteria) this;
        }

        public Criteria andUnitTitleNotEqualTo(String value) {
            addCriterion("unit_title <>", value, "unitTitle");
            return (Criteria) this;
        }

        public Criteria andUnitTitleGreaterThan(String value) {
            addCriterion("unit_title >", value, "unitTitle");
            return (Criteria) this;
        }

        public Criteria andUnitTitleGreaterThanOrEqualTo(String value) {
            addCriterion("unit_title >=", value, "unitTitle");
            return (Criteria) this;
        }

        public Criteria andUnitTitleLessThan(String value) {
            addCriterion("unit_title <", value, "unitTitle");
            return (Criteria) this;
        }

        public Criteria andUnitTitleLessThanOrEqualTo(String value) {
            addCriterion("unit_title <=", value, "unitTitle");
            return (Criteria) this;
        }

        public Criteria andUnitTitleLike(String value) {
            addCriterion("unit_title like", value, "unitTitle");
            return (Criteria) this;
        }

        public Criteria andUnitTitleNotLike(String value) {
            addCriterion("unit_title not like", value, "unitTitle");
            return (Criteria) this;
        }

        public Criteria andUnitTitleIn(List<String> values) {
            addCriterion("unit_title in", values, "unitTitle");
            return (Criteria) this;
        }

        public Criteria andUnitTitleNotIn(List<String> values) {
            addCriterion("unit_title not in", values, "unitTitle");
            return (Criteria) this;
        }

        public Criteria andUnitTitleBetween(String value1, String value2) {
            addCriterion("unit_title between", value1, value2, "unitTitle");
            return (Criteria) this;
        }

        public Criteria andUnitTitleNotBetween(String value1, String value2) {
            addCriterion("unit_title not between", value1, value2, "unitTitle");
            return (Criteria) this;
        }

        public Criteria andSalesBranchCodeIsNull() {
            addCriterion("sales_branch_code is null");
            return (Criteria) this;
        }

        public Criteria andSalesBranchCodeIsNotNull() {
            addCriterion("sales_branch_code is not null");
            return (Criteria) this;
        }

        public Criteria andSalesBranchCodeEqualTo(String value) {
            addCriterion("sales_branch_code =", value, "salesBranchCode");
            return (Criteria) this;
        }

        public Criteria andSalesBranchCodeNotEqualTo(String value) {
            addCriterion("sales_branch_code <>", value, "salesBranchCode");
            return (Criteria) this;
        }

        public Criteria andSalesBranchCodeGreaterThan(String value) {
            addCriterion("sales_branch_code >", value, "salesBranchCode");
            return (Criteria) this;
        }

        public Criteria andSalesBranchCodeGreaterThanOrEqualTo(String value) {
            addCriterion("sales_branch_code >=", value, "salesBranchCode");
            return (Criteria) this;
        }

        public Criteria andSalesBranchCodeLessThan(String value) {
            addCriterion("sales_branch_code <", value, "salesBranchCode");
            return (Criteria) this;
        }

        public Criteria andSalesBranchCodeLessThanOrEqualTo(String value) {
            addCriterion("sales_branch_code <=", value, "salesBranchCode");
            return (Criteria) this;
        }

        public Criteria andSalesBranchCodeLike(String value) {
            addCriterion("sales_branch_code like", value, "salesBranchCode");
            return (Criteria) this;
        }

        public Criteria andSalesBranchCodeNotLike(String value) {
            addCriterion("sales_branch_code not like", value, "salesBranchCode");
            return (Criteria) this;
        }

        public Criteria andSalesBranchCodeIn(List<String> values) {
            addCriterion("sales_branch_code in", values, "salesBranchCode");
            return (Criteria) this;
        }

        public Criteria andSalesBranchCodeNotIn(List<String> values) {
            addCriterion("sales_branch_code not in", values, "salesBranchCode");
            return (Criteria) this;
        }

        public Criteria andSalesBranchCodeBetween(String value1, String value2) {
            addCriterion("sales_branch_code between", value1, value2, "salesBranchCode");
            return (Criteria) this;
        }

        public Criteria andSalesBranchCodeNotBetween(String value1, String value2) {
            addCriterion("sales_branch_code not between", value1, value2, "salesBranchCode");
            return (Criteria) this;
        }

        public Criteria andSalesBranchNameIsNull() {
            addCriterion("sales_branch_name is null");
            return (Criteria) this;
        }

        public Criteria andSalesBranchNameIsNotNull() {
            addCriterion("sales_branch_name is not null");
            return (Criteria) this;
        }

        public Criteria andSalesBranchNameEqualTo(String value) {
            addCriterion("sales_branch_name =", value, "salesBranchName");
            return (Criteria) this;
        }

        public Criteria andSalesBranchNameNotEqualTo(String value) {
            addCriterion("sales_branch_name <>", value, "salesBranchName");
            return (Criteria) this;
        }

        public Criteria andSalesBranchNameGreaterThan(String value) {
            addCriterion("sales_branch_name >", value, "salesBranchName");
            return (Criteria) this;
        }

        public Criteria andSalesBranchNameGreaterThanOrEqualTo(String value) {
            addCriterion("sales_branch_name >=", value, "salesBranchName");
            return (Criteria) this;
        }

        public Criteria andSalesBranchNameLessThan(String value) {
            addCriterion("sales_branch_name <", value, "salesBranchName");
            return (Criteria) this;
        }

        public Criteria andSalesBranchNameLessThanOrEqualTo(String value) {
            addCriterion("sales_branch_name <=", value, "salesBranchName");
            return (Criteria) this;
        }

        public Criteria andSalesBranchNameLike(String value) {
            addCriterion("sales_branch_name like", value, "salesBranchName");
            return (Criteria) this;
        }

        public Criteria andSalesBranchNameNotLike(String value) {
            addCriterion("sales_branch_name not like", value, "salesBranchName");
            return (Criteria) this;
        }

        public Criteria andSalesBranchNameIn(List<String> values) {
            addCriterion("sales_branch_name in", values, "salesBranchName");
            return (Criteria) this;
        }

        public Criteria andSalesBranchNameNotIn(List<String> values) {
            addCriterion("sales_branch_name not in", values, "salesBranchName");
            return (Criteria) this;
        }

        public Criteria andSalesBranchNameBetween(String value1, String value2) {
            addCriterion("sales_branch_name between", value1, value2, "salesBranchName");
            return (Criteria) this;
        }

        public Criteria andSalesBranchNameNotBetween(String value1, String value2) {
            addCriterion("sales_branch_name not between", value1, value2, "salesBranchName");
            return (Criteria) this;
        }

        public Criteria andSiteCodeIsNull() {
            addCriterion("site_code is null");
            return (Criteria) this;
        }

        public Criteria andSiteCodeIsNotNull() {
            addCriterion("site_code is not null");
            return (Criteria) this;
        }

        public Criteria andSiteCodeEqualTo(String value) {
            addCriterion("site_code =", value, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeNotEqualTo(String value) {
            addCriterion("site_code <>", value, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeGreaterThan(String value) {
            addCriterion("site_code >", value, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeGreaterThanOrEqualTo(String value) {
            addCriterion("site_code >=", value, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeLessThan(String value) {
            addCriterion("site_code <", value, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeLessThanOrEqualTo(String value) {
            addCriterion("site_code <=", value, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeLike(String value) {
            addCriterion("site_code like", value, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeNotLike(String value) {
            addCriterion("site_code not like", value, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeIn(List<String> values) {
            addCriterion("site_code in", values, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeNotIn(List<String> values) {
            addCriterion("site_code not in", values, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeBetween(String value1, String value2) {
            addCriterion("site_code between", value1, value2, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeNotBetween(String value1, String value2) {
            addCriterion("site_code not between", value1, value2, "siteCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeIsNull() {
            addCriterion("channel_code is null");
            return (Criteria) this;
        }

        public Criteria andChannelCodeIsNotNull() {
            addCriterion("channel_code is not null");
            return (Criteria) this;
        }

        public Criteria andChannelCodeEqualTo(String value) {
            addCriterion("channel_code =", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeNotEqualTo(String value) {
            addCriterion("channel_code <>", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeGreaterThan(String value) {
            addCriterion("channel_code >", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeGreaterThanOrEqualTo(String value) {
            addCriterion("channel_code >=", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeLessThan(String value) {
            addCriterion("channel_code <", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeLessThanOrEqualTo(String value) {
            addCriterion("channel_code <=", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeLike(String value) {
            addCriterion("channel_code like", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeNotLike(String value) {
            addCriterion("channel_code not like", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeIn(List<String> values) {
            addCriterion("channel_code in", values, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeNotIn(List<String> values) {
            addCriterion("channel_code not in", values, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeBetween(String value1, String value2) {
            addCriterion("channel_code between", value1, value2, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeNotBetween(String value1, String value2) {
            addCriterion("channel_code not between", value1, value2, "channelCode");
            return (Criteria) this;
        }

        public Criteria andShopNameIsNull() {
            addCriterion("shop_name is null");
            return (Criteria) this;
        }

        public Criteria andShopNameIsNotNull() {
            addCriterion("shop_name is not null");
            return (Criteria) this;
        }

        public Criteria andShopNameEqualTo(String value) {
            addCriterion("shop_name =", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotEqualTo(String value) {
            addCriterion("shop_name <>", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameGreaterThan(String value) {
            addCriterion("shop_name >", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameGreaterThanOrEqualTo(String value) {
            addCriterion("shop_name >=", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameLessThan(String value) {
            addCriterion("shop_name <", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameLessThanOrEqualTo(String value) {
            addCriterion("shop_name <=", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameLike(String value) {
            addCriterion("shop_name like", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotLike(String value) {
            addCriterion("shop_name not like", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameIn(List<String> values) {
            addCriterion("shop_name in", values, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotIn(List<String> values) {
            addCriterion("shop_name not in", values, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameBetween(String value1, String value2) {
            addCriterion("shop_name between", value1, value2, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotBetween(String value1, String value2) {
            addCriterion("shop_name not between", value1, value2, "shopName");
            return (Criteria) this;
        }

        public Criteria andUserMobileIsNull() {
            addCriterion("user_mobile is null");
            return (Criteria) this;
        }

        public Criteria andUserMobileIsNotNull() {
            addCriterion("user_mobile is not null");
            return (Criteria) this;
        }

        public Criteria andUserMobileEqualTo(String value) {
            addCriterion("user_mobile =", value, "userMobile");
            return (Criteria) this;
        }

        public Criteria andUserMobileNotEqualTo(String value) {
            addCriterion("user_mobile <>", value, "userMobile");
            return (Criteria) this;
        }

        public Criteria andUserMobileGreaterThan(String value) {
            addCriterion("user_mobile >", value, "userMobile");
            return (Criteria) this;
        }

        public Criteria andUserMobileGreaterThanOrEqualTo(String value) {
            addCriterion("user_mobile >=", value, "userMobile");
            return (Criteria) this;
        }

        public Criteria andUserMobileLessThan(String value) {
            addCriterion("user_mobile <", value, "userMobile");
            return (Criteria) this;
        }

        public Criteria andUserMobileLessThanOrEqualTo(String value) {
            addCriterion("user_mobile <=", value, "userMobile");
            return (Criteria) this;
        }

        public Criteria andUserMobileLike(String value) {
            addCriterion("user_mobile like", value, "userMobile");
            return (Criteria) this;
        }

        public Criteria andUserMobileNotLike(String value) {
            addCriterion("user_mobile not like", value, "userMobile");
            return (Criteria) this;
        }

        public Criteria andUserMobileIn(List<String> values) {
            addCriterion("user_mobile in", values, "userMobile");
            return (Criteria) this;
        }

        public Criteria andUserMobileNotIn(List<String> values) {
            addCriterion("user_mobile not in", values, "userMobile");
            return (Criteria) this;
        }

        public Criteria andUserMobileBetween(String value1, String value2) {
            addCriterion("user_mobile between", value1, value2, "userMobile");
            return (Criteria) this;
        }

        public Criteria andUserMobileNotBetween(String value1, String value2) {
            addCriterion("user_mobile not between", value1, value2, "userMobile");
            return (Criteria) this;
        }

        public Criteria andShipCancelStatusIsNull() {
            addCriterion("ship_cancel_status is null");
            return (Criteria) this;
        }

        public Criteria andShipCancelStatusIsNotNull() {
            addCriterion("ship_cancel_status is not null");
            return (Criteria) this;
        }

        public Criteria andShipCancelStatusEqualTo(Integer value) {
            addCriterion("ship_cancel_status =", value, "shipCancelStatus");
            return (Criteria) this;
        }

        public Criteria andShipCancelStatusNotEqualTo(Integer value) {
            addCriterion("ship_cancel_status <>", value, "shipCancelStatus");
            return (Criteria) this;
        }

        public Criteria andShipCancelStatusGreaterThan(Integer value) {
            addCriterion("ship_cancel_status >", value, "shipCancelStatus");
            return (Criteria) this;
        }

        public Criteria andShipCancelStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("ship_cancel_status >=", value, "shipCancelStatus");
            return (Criteria) this;
        }

        public Criteria andShipCancelStatusLessThan(Integer value) {
            addCriterion("ship_cancel_status <", value, "shipCancelStatus");
            return (Criteria) this;
        }

        public Criteria andShipCancelStatusLessThanOrEqualTo(Integer value) {
            addCriterion("ship_cancel_status <=", value, "shipCancelStatus");
            return (Criteria) this;
        }

        public Criteria andShipCancelStatusIn(List<Integer> values) {
            addCriterion("ship_cancel_status in", values, "shipCancelStatus");
            return (Criteria) this;
        }

        public Criteria andShipCancelStatusNotIn(List<Integer> values) {
            addCriterion("ship_cancel_status not in", values, "shipCancelStatus");
            return (Criteria) this;
        }

        public Criteria andShipCancelStatusBetween(Integer value1, Integer value2) {
            addCriterion("ship_cancel_status between", value1, value2, "shipCancelStatus");
            return (Criteria) this;
        }

        public Criteria andShipCancelStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("ship_cancel_status not between", value1, value2, "shipCancelStatus");
            return (Criteria) this;
        }

        public Criteria andPalletMerchantIsNull() {
            addCriterion("pallet_merchant is null");
            return (Criteria) this;
        }

        public Criteria andPalletMerchantIsNotNull() {
            addCriterion("pallet_merchant is not null");
            return (Criteria) this;
        }

        public Criteria andPalletMerchantEqualTo(String value) {
            addCriterion("pallet_merchant =", value, "palletMerchant");
            return (Criteria) this;
        }

        public Criteria andPalletMerchantNotEqualTo(String value) {
            addCriterion("pallet_merchant <>", value, "palletMerchant");
            return (Criteria) this;
        }

        public Criteria andPalletMerchantGreaterThan(String value) {
            addCriterion("pallet_merchant >", value, "palletMerchant");
            return (Criteria) this;
        }

        public Criteria andPalletMerchantGreaterThanOrEqualTo(String value) {
            addCriterion("pallet_merchant >=", value, "palletMerchant");
            return (Criteria) this;
        }

        public Criteria andPalletMerchantLessThan(String value) {
            addCriterion("pallet_merchant <", value, "palletMerchant");
            return (Criteria) this;
        }

        public Criteria andPalletMerchantLessThanOrEqualTo(String value) {
            addCriterion("pallet_merchant <=", value, "palletMerchant");
            return (Criteria) this;
        }

        public Criteria andPalletMerchantLike(String value) {
            addCriterion("pallet_merchant like", value, "palletMerchant");
            return (Criteria) this;
        }

        public Criteria andPalletMerchantNotLike(String value) {
            addCriterion("pallet_merchant not like", value, "palletMerchant");
            return (Criteria) this;
        }

        public Criteria andPalletMerchantIn(List<String> values) {
            addCriterion("pallet_merchant in", values, "palletMerchant");
            return (Criteria) this;
        }

        public Criteria andPalletMerchantNotIn(List<String> values) {
            addCriterion("pallet_merchant not in", values, "palletMerchant");
            return (Criteria) this;
        }

        public Criteria andPalletMerchantBetween(String value1, String value2) {
            addCriterion("pallet_merchant between", value1, value2, "palletMerchant");
            return (Criteria) this;
        }

        public Criteria andPalletMerchantNotBetween(String value1, String value2) {
            addCriterion("pallet_merchant not between", value1, value2, "palletMerchant");
            return (Criteria) this;
        }

        public Criteria andInsteadUserNameIsNull() {
            addCriterion("instead_user_name is null");
            return (Criteria) this;
        }

        public Criteria andInsteadUserNameIsNotNull() {
            addCriterion("instead_user_name is not null");
            return (Criteria) this;
        }

        public Criteria andInsteadUserNameEqualTo(String value) {
            addCriterion("instead_user_name =", value, "insteadUserName");
            return (Criteria) this;
        }

        public Criteria andInsteadUserNameNotEqualTo(String value) {
            addCriterion("instead_user_name <>", value, "insteadUserName");
            return (Criteria) this;
        }

        public Criteria andInsteadUserNameGreaterThan(String value) {
            addCriterion("instead_user_name >", value, "insteadUserName");
            return (Criteria) this;
        }

        public Criteria andInsteadUserNameGreaterThanOrEqualTo(String value) {
            addCriterion("instead_user_name >=", value, "insteadUserName");
            return (Criteria) this;
        }

        public Criteria andInsteadUserNameLessThan(String value) {
            addCriterion("instead_user_name <", value, "insteadUserName");
            return (Criteria) this;
        }

        public Criteria andInsteadUserNameLessThanOrEqualTo(String value) {
            addCriterion("instead_user_name <=", value, "insteadUserName");
            return (Criteria) this;
        }

        public Criteria andInsteadUserNameLike(String value) {
            addCriterion("instead_user_name like", value, "insteadUserName");
            return (Criteria) this;
        }

        public Criteria andInsteadUserNameNotLike(String value) {
            addCriterion("instead_user_name not like", value, "insteadUserName");
            return (Criteria) this;
        }

        public Criteria andInsteadUserNameIn(List<String> values) {
            addCriterion("instead_user_name in", values, "insteadUserName");
            return (Criteria) this;
        }

        public Criteria andInsteadUserNameNotIn(List<String> values) {
            addCriterion("instead_user_name not in", values, "insteadUserName");
            return (Criteria) this;
        }

        public Criteria andInsteadUserNameBetween(String value1, String value2) {
            addCriterion("instead_user_name between", value1, value2, "insteadUserName");
            return (Criteria) this;
        }

        public Criteria andInsteadUserNameNotBetween(String value1, String value2) {
            addCriterion("instead_user_name not between", value1, value2, "insteadUserName");
            return (Criteria) this;
        }

        public Criteria andCustomerContractNumIsNull() {
            addCriterion("customer_contract_num is null");
            return (Criteria) this;
        }

        public Criteria andCustomerContractNumIsNotNull() {
            addCriterion("customer_contract_num is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerContractNumEqualTo(String value) {
            addCriterion("customer_contract_num =", value, "customerContractNum");
            return (Criteria) this;
        }

        public Criteria andCustomerContractNumNotEqualTo(String value) {
            addCriterion("customer_contract_num <>", value, "customerContractNum");
            return (Criteria) this;
        }

        public Criteria andCustomerContractNumGreaterThan(String value) {
            addCriterion("customer_contract_num >", value, "customerContractNum");
            return (Criteria) this;
        }

        public Criteria andCustomerContractNumGreaterThanOrEqualTo(String value) {
            addCriterion("customer_contract_num >=", value, "customerContractNum");
            return (Criteria) this;
        }

        public Criteria andCustomerContractNumLessThan(String value) {
            addCriterion("customer_contract_num <", value, "customerContractNum");
            return (Criteria) this;
        }

        public Criteria andCustomerContractNumLessThanOrEqualTo(String value) {
            addCriterion("customer_contract_num <=", value, "customerContractNum");
            return (Criteria) this;
        }

        public Criteria andCustomerContractNumLike(String value) {
            addCriterion("customer_contract_num like", value, "customerContractNum");
            return (Criteria) this;
        }

        public Criteria andCustomerContractNumNotLike(String value) {
            addCriterion("customer_contract_num not like", value, "customerContractNum");
            return (Criteria) this;
        }

        public Criteria andCustomerContractNumIn(List<String> values) {
            addCriterion("customer_contract_num in", values, "customerContractNum");
            return (Criteria) this;
        }

        public Criteria andCustomerContractNumNotIn(List<String> values) {
            addCriterion("customer_contract_num not in", values, "customerContractNum");
            return (Criteria) this;
        }

        public Criteria andCustomerContractNumBetween(String value1, String value2) {
            addCriterion("customer_contract_num between", value1, value2, "customerContractNum");
            return (Criteria) this;
        }

        public Criteria andCustomerContractNumNotBetween(String value1, String value2) {
            addCriterion("customer_contract_num not between", value1, value2, "customerContractNum");
            return (Criteria) this;
        }

        public Criteria andProductTypeNoIsNull() {
            addCriterion("product_type_no is null");
            return (Criteria) this;
        }

        public Criteria andProductTypeNoIsNotNull() {
            addCriterion("product_type_no is not null");
            return (Criteria) this;
        }

        public Criteria andProductTypeNoEqualTo(String value) {
            addCriterion("product_type_no =", value, "productTypeNo");
            return (Criteria) this;
        }

        public Criteria andProductTypeNoNotEqualTo(String value) {
            addCriterion("product_type_no <>", value, "productTypeNo");
            return (Criteria) this;
        }

        public Criteria andProductTypeNoGreaterThan(String value) {
            addCriterion("product_type_no >", value, "productTypeNo");
            return (Criteria) this;
        }

        public Criteria andProductTypeNoGreaterThanOrEqualTo(String value) {
            addCriterion("product_type_no >=", value, "productTypeNo");
            return (Criteria) this;
        }

        public Criteria andProductTypeNoLessThan(String value) {
            addCriterion("product_type_no <", value, "productTypeNo");
            return (Criteria) this;
        }

        public Criteria andProductTypeNoLessThanOrEqualTo(String value) {
            addCriterion("product_type_no <=", value, "productTypeNo");
            return (Criteria) this;
        }

        public Criteria andProductTypeNoLike(String value) {
            addCriterion("product_type_no like", value, "productTypeNo");
            return (Criteria) this;
        }

        public Criteria andProductTypeNoNotLike(String value) {
            addCriterion("product_type_no not like", value, "productTypeNo");
            return (Criteria) this;
        }

        public Criteria andProductTypeNoIn(List<String> values) {
            addCriterion("product_type_no in", values, "productTypeNo");
            return (Criteria) this;
        }

        public Criteria andProductTypeNoNotIn(List<String> values) {
            addCriterion("product_type_no not in", values, "productTypeNo");
            return (Criteria) this;
        }

        public Criteria andProductTypeNoBetween(String value1, String value2) {
            addCriterion("product_type_no between", value1, value2, "productTypeNo");
            return (Criteria) this;
        }

        public Criteria andProductTypeNoNotBetween(String value1, String value2) {
            addCriterion("product_type_no not between", value1, value2, "productTypeNo");
            return (Criteria) this;
        }

        public Criteria andWeightMethodIsNull() {
            addCriterion("weight_method is null");
            return (Criteria) this;
        }

        public Criteria andWeightMethodIsNotNull() {
            addCriterion("weight_method is not null");
            return (Criteria) this;
        }

        public Criteria andWeightMethodEqualTo(String value) {
            addCriterion("weight_method =", value, "weightMethod");
            return (Criteria) this;
        }

        public Criteria andWeightMethodNotEqualTo(String value) {
            addCriterion("weight_method <>", value, "weightMethod");
            return (Criteria) this;
        }

        public Criteria andWeightMethodGreaterThan(String value) {
            addCriterion("weight_method >", value, "weightMethod");
            return (Criteria) this;
        }

        public Criteria andWeightMethodGreaterThanOrEqualTo(String value) {
            addCriterion("weight_method >=", value, "weightMethod");
            return (Criteria) this;
        }

        public Criteria andWeightMethodLessThan(String value) {
            addCriterion("weight_method <", value, "weightMethod");
            return (Criteria) this;
        }

        public Criteria andWeightMethodLessThanOrEqualTo(String value) {
            addCriterion("weight_method <=", value, "weightMethod");
            return (Criteria) this;
        }

        public Criteria andWeightMethodLike(String value) {
            addCriterion("weight_method like", value, "weightMethod");
            return (Criteria) this;
        }

        public Criteria andWeightMethodNotLike(String value) {
            addCriterion("weight_method not like", value, "weightMethod");
            return (Criteria) this;
        }

        public Criteria andWeightMethodIn(List<String> values) {
            addCriterion("weight_method in", values, "weightMethod");
            return (Criteria) this;
        }

        public Criteria andWeightMethodNotIn(List<String> values) {
            addCriterion("weight_method not in", values, "weightMethod");
            return (Criteria) this;
        }

        public Criteria andWeightMethodBetween(String value1, String value2) {
            addCriterion("weight_method between", value1, value2, "weightMethod");
            return (Criteria) this;
        }

        public Criteria andWeightMethodNotBetween(String value1, String value2) {
            addCriterion("weight_method not between", value1, value2, "weightMethod");
            return (Criteria) this;
        }

        public Criteria andSettlementTypeIsNull() {
            addCriterion("settlement_type is null");
            return (Criteria) this;
        }

        public Criteria andSettlementTypeIsNotNull() {
            addCriterion("settlement_type is not null");
            return (Criteria) this;
        }

        public Criteria andSettlementTypeEqualTo(Integer value) {
            addCriterion("settlement_type =", value, "settlementType");
            return (Criteria) this;
        }

        public Criteria andSettlementTypeNotEqualTo(Integer value) {
            addCriterion("settlement_type <>", value, "settlementType");
            return (Criteria) this;
        }

        public Criteria andSettlementTypeGreaterThan(Integer value) {
            addCriterion("settlement_type >", value, "settlementType");
            return (Criteria) this;
        }

        public Criteria andSettlementTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("settlement_type >=", value, "settlementType");
            return (Criteria) this;
        }

        public Criteria andSettlementTypeLessThan(Integer value) {
            addCriterion("settlement_type <", value, "settlementType");
            return (Criteria) this;
        }

        public Criteria andSettlementTypeLessThanOrEqualTo(Integer value) {
            addCriterion("settlement_type <=", value, "settlementType");
            return (Criteria) this;
        }

        public Criteria andSettlementTypeIn(List<Integer> values) {
            addCriterion("settlement_type in", values, "settlementType");
            return (Criteria) this;
        }

        public Criteria andSettlementTypeNotIn(List<Integer> values) {
            addCriterion("settlement_type not in", values, "settlementType");
            return (Criteria) this;
        }

        public Criteria andSettlementTypeBetween(Integer value1, Integer value2) {
            addCriterion("settlement_type between", value1, value2, "settlementType");
            return (Criteria) this;
        }

        public Criteria andSettlementTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("settlement_type not between", value1, value2, "settlementType");
            return (Criteria) this;
        }

        public Criteria andSettlementTicketIsNull() {
            addCriterion("settlement_ticket is null");
            return (Criteria) this;
        }

        public Criteria andSettlementTicketIsNotNull() {
            addCriterion("settlement_ticket is not null");
            return (Criteria) this;
        }

        public Criteria andSettlementTicketEqualTo(String value) {
            addCriterion("settlement_ticket =", value, "settlementTicket");
            return (Criteria) this;
        }

        public Criteria andSettlementTicketNotEqualTo(String value) {
            addCriterion("settlement_ticket <>", value, "settlementTicket");
            return (Criteria) this;
        }

        public Criteria andSettlementTicketGreaterThan(String value) {
            addCriterion("settlement_ticket >", value, "settlementTicket");
            return (Criteria) this;
        }

        public Criteria andSettlementTicketGreaterThanOrEqualTo(String value) {
            addCriterion("settlement_ticket >=", value, "settlementTicket");
            return (Criteria) this;
        }

        public Criteria andSettlementTicketLessThan(String value) {
            addCriterion("settlement_ticket <", value, "settlementTicket");
            return (Criteria) this;
        }

        public Criteria andSettlementTicketLessThanOrEqualTo(String value) {
            addCriterion("settlement_ticket <=", value, "settlementTicket");
            return (Criteria) this;
        }

        public Criteria andSettlementTicketLike(String value) {
            addCriterion("settlement_ticket like", value, "settlementTicket");
            return (Criteria) this;
        }

        public Criteria andSettlementTicketNotLike(String value) {
            addCriterion("settlement_ticket not like", value, "settlementTicket");
            return (Criteria) this;
        }

        public Criteria andSettlementTicketIn(List<String> values) {
            addCriterion("settlement_ticket in", values, "settlementTicket");
            return (Criteria) this;
        }

        public Criteria andSettlementTicketNotIn(List<String> values) {
            addCriterion("settlement_ticket not in", values, "settlementTicket");
            return (Criteria) this;
        }

        public Criteria andSettlementTicketBetween(String value1, String value2) {
            addCriterion("settlement_ticket between", value1, value2, "settlementTicket");
            return (Criteria) this;
        }

        public Criteria andSettlementTicketNotBetween(String value1, String value2) {
            addCriterion("settlement_ticket not between", value1, value2, "settlementTicket");
            return (Criteria) this;
        }

        public Criteria andProtocolTypeIsNull() {
            addCriterion("protocol_type is null");
            return (Criteria) this;
        }

        public Criteria andProtocolTypeIsNotNull() {
            addCriterion("protocol_type is not null");
            return (Criteria) this;
        }

        public Criteria andProtocolTypeEqualTo(Integer value) {
            addCriterion("protocol_type =", value, "protocolType");
            return (Criteria) this;
        }

        public Criteria andProtocolTypeNotEqualTo(Integer value) {
            addCriterion("protocol_type <>", value, "protocolType");
            return (Criteria) this;
        }

        public Criteria andProtocolTypeGreaterThan(Integer value) {
            addCriterion("protocol_type >", value, "protocolType");
            return (Criteria) this;
        }

        public Criteria andProtocolTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("protocol_type >=", value, "protocolType");
            return (Criteria) this;
        }

        public Criteria andProtocolTypeLessThan(Integer value) {
            addCriterion("protocol_type <", value, "protocolType");
            return (Criteria) this;
        }

        public Criteria andProtocolTypeLessThanOrEqualTo(Integer value) {
            addCriterion("protocol_type <=", value, "protocolType");
            return (Criteria) this;
        }

        public Criteria andProtocolTypeIn(List<Integer> values) {
            addCriterion("protocol_type in", values, "protocolType");
            return (Criteria) this;
        }

        public Criteria andProtocolTypeNotIn(List<Integer> values) {
            addCriterion("protocol_type not in", values, "protocolType");
            return (Criteria) this;
        }

        public Criteria andProtocolTypeBetween(Integer value1, Integer value2) {
            addCriterion("protocol_type between", value1, value2, "protocolType");
            return (Criteria) this;
        }

        public Criteria andProtocolTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("protocol_type not between", value1, value2, "protocolType");
            return (Criteria) this;
        }

        public Criteria andVersionIsNull() {
            addCriterion("version is null");
            return (Criteria) this;
        }

        public Criteria andVersionIsNotNull() {
            addCriterion("version is not null");
            return (Criteria) this;
        }

        public Criteria andVersionEqualTo(Integer value) {
            addCriterion("version =", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionNotEqualTo(Integer value) {
            addCriterion("version <>", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionGreaterThan(Integer value) {
            addCriterion("version >", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionGreaterThanOrEqualTo(Integer value) {
            addCriterion("version >=", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionLessThan(Integer value) {
            addCriterion("version <", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionLessThanOrEqualTo(Integer value) {
            addCriterion("version <=", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionIn(List<Integer> values) {
            addCriterion("version in", values, "version");
            return (Criteria) this;
        }

        public Criteria andVersionNotIn(List<Integer> values) {
            addCriterion("version not in", values, "version");
            return (Criteria) this;
        }

        public Criteria andVersionBetween(Integer value1, Integer value2) {
            addCriterion("version between", value1, value2, "version");
            return (Criteria) this;
        }

        public Criteria andVersionNotBetween(Integer value1, Integer value2) {
            addCriterion("version not between", value1, value2, "version");
            return (Criteria) this;
        }

        public Criteria andTypeOfCarriageIsNull() {
            addCriterion("type_of_carriage is null");
            return (Criteria) this;
        }

        public Criteria andTypeOfCarriageIsNotNull() {
            addCriterion("type_of_carriage is not null");
            return (Criteria) this;
        }

        public Criteria andTypeOfCarriageEqualTo(String value) {
            addCriterion("type_of_carriage =", value, "typeOfCarriage");
            return (Criteria) this;
        }

        public Criteria andTypeOfCarriageNotEqualTo(String value) {
            addCriterion("type_of_carriage <>", value, "typeOfCarriage");
            return (Criteria) this;
        }

        public Criteria andTypeOfCarriageGreaterThan(String value) {
            addCriterion("type_of_carriage >", value, "typeOfCarriage");
            return (Criteria) this;
        }

        public Criteria andTypeOfCarriageGreaterThanOrEqualTo(String value) {
            addCriterion("type_of_carriage >=", value, "typeOfCarriage");
            return (Criteria) this;
        }

        public Criteria andTypeOfCarriageLessThan(String value) {
            addCriterion("type_of_carriage <", value, "typeOfCarriage");
            return (Criteria) this;
        }

        public Criteria andTypeOfCarriageLessThanOrEqualTo(String value) {
            addCriterion("type_of_carriage <=", value, "typeOfCarriage");
            return (Criteria) this;
        }

        public Criteria andTypeOfCarriageLike(String value) {
            addCriterion("type_of_carriage like", value, "typeOfCarriage");
            return (Criteria) this;
        }

        public Criteria andTypeOfCarriageNotLike(String value) {
            addCriterion("type_of_carriage not like", value, "typeOfCarriage");
            return (Criteria) this;
        }

        public Criteria andTypeOfCarriageIn(List<String> values) {
            addCriterion("type_of_carriage in", values, "typeOfCarriage");
            return (Criteria) this;
        }

        public Criteria andTypeOfCarriageNotIn(List<String> values) {
            addCriterion("type_of_carriage not in", values, "typeOfCarriage");
            return (Criteria) this;
        }

        public Criteria andTypeOfCarriageBetween(String value1, String value2) {
            addCriterion("type_of_carriage between", value1, value2, "typeOfCarriage");
            return (Criteria) this;
        }

        public Criteria andTypeOfCarriageNotBetween(String value1, String value2) {
            addCriterion("type_of_carriage not between", value1, value2, "typeOfCarriage");
            return (Criteria) this;
        }

        public Criteria andConsignorNameIsNull() {
            addCriterion("consignor_name is null");
            return (Criteria) this;
        }

        public Criteria andConsignorNameIsNotNull() {
            addCriterion("consignor_name is not null");
            return (Criteria) this;
        }

        public Criteria andConsignorNameEqualTo(String value) {
            addCriterion("consignor_name =", value, "consignorName");
            return (Criteria) this;
        }

        public Criteria andConsignorNameNotEqualTo(String value) {
            addCriterion("consignor_name <>", value, "consignorName");
            return (Criteria) this;
        }

        public Criteria andConsignorNameGreaterThan(String value) {
            addCriterion("consignor_name >", value, "consignorName");
            return (Criteria) this;
        }

        public Criteria andConsignorNameGreaterThanOrEqualTo(String value) {
            addCriterion("consignor_name >=", value, "consignorName");
            return (Criteria) this;
        }

        public Criteria andConsignorNameLessThan(String value) {
            addCriterion("consignor_name <", value, "consignorName");
            return (Criteria) this;
        }

        public Criteria andConsignorNameLessThanOrEqualTo(String value) {
            addCriterion("consignor_name <=", value, "consignorName");
            return (Criteria) this;
        }

        public Criteria andConsignorNameLike(String value) {
            addCriterion("consignor_name like", value, "consignorName");
            return (Criteria) this;
        }

        public Criteria andConsignorNameNotLike(String value) {
            addCriterion("consignor_name not like", value, "consignorName");
            return (Criteria) this;
        }

        public Criteria andConsignorNameIn(List<String> values) {
            addCriterion("consignor_name in", values, "consignorName");
            return (Criteria) this;
        }

        public Criteria andConsignorNameNotIn(List<String> values) {
            addCriterion("consignor_name not in", values, "consignorName");
            return (Criteria) this;
        }

        public Criteria andConsignorNameBetween(String value1, String value2) {
            addCriterion("consignor_name between", value1, value2, "consignorName");
            return (Criteria) this;
        }

        public Criteria andConsignorNameNotBetween(String value1, String value2) {
            addCriterion("consignor_name not between", value1, value2, "consignorName");
            return (Criteria) this;
        }

        public Criteria andConsignorCodeIsNull() {
            addCriterion("consignor_code is null");
            return (Criteria) this;
        }

        public Criteria andConsignorCodeIsNotNull() {
            addCriterion("consignor_code is not null");
            return (Criteria) this;
        }

        public Criteria andConsignorCodeEqualTo(String value) {
            addCriterion("consignor_code =", value, "consignorCode");
            return (Criteria) this;
        }

        public Criteria andConsignorCodeNotEqualTo(String value) {
            addCriterion("consignor_code <>", value, "consignorCode");
            return (Criteria) this;
        }

        public Criteria andConsignorCodeGreaterThan(String value) {
            addCriterion("consignor_code >", value, "consignorCode");
            return (Criteria) this;
        }

        public Criteria andConsignorCodeGreaterThanOrEqualTo(String value) {
            addCriterion("consignor_code >=", value, "consignorCode");
            return (Criteria) this;
        }

        public Criteria andConsignorCodeLessThan(String value) {
            addCriterion("consignor_code <", value, "consignorCode");
            return (Criteria) this;
        }

        public Criteria andConsignorCodeLessThanOrEqualTo(String value) {
            addCriterion("consignor_code <=", value, "consignorCode");
            return (Criteria) this;
        }

        public Criteria andConsignorCodeLike(String value) {
            addCriterion("consignor_code like", value, "consignorCode");
            return (Criteria) this;
        }

        public Criteria andConsignorCodeNotLike(String value) {
            addCriterion("consignor_code not like", value, "consignorCode");
            return (Criteria) this;
        }

        public Criteria andConsignorCodeIn(List<String> values) {
            addCriterion("consignor_code in", values, "consignorCode");
            return (Criteria) this;
        }

        public Criteria andConsignorCodeNotIn(List<String> values) {
            addCriterion("consignor_code not in", values, "consignorCode");
            return (Criteria) this;
        }

        public Criteria andConsignorCodeBetween(String value1, String value2) {
            addCriterion("consignor_code between", value1, value2, "consignorCode");
            return (Criteria) this;
        }

        public Criteria andConsignorCodeNotBetween(String value1, String value2) {
            addCriterion("consignor_code not between", value1, value2, "consignorCode");
            return (Criteria) this;
        }

        public Criteria andAccountNumberIsNull() {
            addCriterion("account_number is null");
            return (Criteria) this;
        }

        public Criteria andAccountNumberIsNotNull() {
            addCriterion("account_number is not null");
            return (Criteria) this;
        }

        public Criteria andAccountNumberEqualTo(String value) {
            addCriterion("account_number =", value, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andAccountNumberNotEqualTo(String value) {
            addCriterion("account_number <>", value, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andAccountNumberGreaterThan(String value) {
            addCriterion("account_number >", value, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andAccountNumberGreaterThanOrEqualTo(String value) {
            addCriterion("account_number >=", value, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andAccountNumberLessThan(String value) {
            addCriterion("account_number <", value, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andAccountNumberLessThanOrEqualTo(String value) {
            addCriterion("account_number <=", value, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andAccountNumberLike(String value) {
            addCriterion("account_number like", value, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andAccountNumberNotLike(String value) {
            addCriterion("account_number not like", value, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andAccountNumberIn(List<String> values) {
            addCriterion("account_number in", values, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andAccountNumberNotIn(List<String> values) {
            addCriterion("account_number not in", values, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andAccountNumberBetween(String value1, String value2) {
            addCriterion("account_number between", value1, value2, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andAccountNumberNotBetween(String value1, String value2) {
            addCriterion("account_number not between", value1, value2, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andShippingUnitPriceIsNull() {
            addCriterion("shipping_unit_price is null");
            return (Criteria) this;
        }

        public Criteria andShippingUnitPriceIsNotNull() {
            addCriterion("shipping_unit_price is not null");
            return (Criteria) this;
        }

        public Criteria andShippingUnitPriceEqualTo(BigDecimal value) {
            addCriterion("shipping_unit_price =", value, "shippingUnitPrice");
            return (Criteria) this;
        }

        public Criteria andShippingUnitPriceNotEqualTo(BigDecimal value) {
            addCriterion("shipping_unit_price <>", value, "shippingUnitPrice");
            return (Criteria) this;
        }

        public Criteria andShippingUnitPriceGreaterThan(BigDecimal value) {
            addCriterion("shipping_unit_price >", value, "shippingUnitPrice");
            return (Criteria) this;
        }

        public Criteria andShippingUnitPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("shipping_unit_price >=", value, "shippingUnitPrice");
            return (Criteria) this;
        }

        public Criteria andShippingUnitPriceLessThan(BigDecimal value) {
            addCriterion("shipping_unit_price <", value, "shippingUnitPrice");
            return (Criteria) this;
        }

        public Criteria andShippingUnitPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("shipping_unit_price <=", value, "shippingUnitPrice");
            return (Criteria) this;
        }

        public Criteria andShippingUnitPriceIn(List<BigDecimal> values) {
            addCriterion("shipping_unit_price in", values, "shippingUnitPrice");
            return (Criteria) this;
        }

        public Criteria andShippingUnitPriceNotIn(List<BigDecimal> values) {
            addCriterion("shipping_unit_price not in", values, "shippingUnitPrice");
            return (Criteria) this;
        }

        public Criteria andShippingUnitPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("shipping_unit_price between", value1, value2, "shippingUnitPrice");
            return (Criteria) this;
        }

        public Criteria andShippingUnitPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("shipping_unit_price not between", value1, value2, "shippingUnitPrice");
            return (Criteria) this;
        }

        public Criteria andIsIncludedPriceIsNull() {
            addCriterion("is_included_price is null");
            return (Criteria) this;
        }

        public Criteria andIsIncludedPriceIsNotNull() {
            addCriterion("is_included_price is not null");
            return (Criteria) this;
        }

        public Criteria andIsIncludedPriceEqualTo(Integer value) {
            addCriterion("is_included_price =", value, "isIncludedPrice");
            return (Criteria) this;
        }

        public Criteria andIsIncludedPriceNotEqualTo(Integer value) {
            addCriterion("is_included_price <>", value, "isIncludedPrice");
            return (Criteria) this;
        }

        public Criteria andIsIncludedPriceGreaterThan(Integer value) {
            addCriterion("is_included_price >", value, "isIncludedPrice");
            return (Criteria) this;
        }

        public Criteria andIsIncludedPriceGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_included_price >=", value, "isIncludedPrice");
            return (Criteria) this;
        }

        public Criteria andIsIncludedPriceLessThan(Integer value) {
            addCriterion("is_included_price <", value, "isIncludedPrice");
            return (Criteria) this;
        }

        public Criteria andIsIncludedPriceLessThanOrEqualTo(Integer value) {
            addCriterion("is_included_price <=", value, "isIncludedPrice");
            return (Criteria) this;
        }

        public Criteria andIsIncludedPriceIn(List<Integer> values) {
            addCriterion("is_included_price in", values, "isIncludedPrice");
            return (Criteria) this;
        }

        public Criteria andIsIncludedPriceNotIn(List<Integer> values) {
            addCriterion("is_included_price not in", values, "isIncludedPrice");
            return (Criteria) this;
        }

        public Criteria andIsIncludedPriceBetween(Integer value1, Integer value2) {
            addCriterion("is_included_price between", value1, value2, "isIncludedPrice");
            return (Criteria) this;
        }

        public Criteria andIsIncludedPriceNotBetween(Integer value1, Integer value2) {
            addCriterion("is_included_price not between", value1, value2, "isIncludedPrice");
            return (Criteria) this;
        }

        public Criteria andCarNumberIsNull() {
            addCriterion("car_number is null");
            return (Criteria) this;
        }

        public Criteria andCarNumberIsNotNull() {
            addCriterion("car_number is not null");
            return (Criteria) this;
        }

        public Criteria andCarNumberEqualTo(String value) {
            addCriterion("car_number =", value, "carNumber");
            return (Criteria) this;
        }

        public Criteria andCarNumberNotEqualTo(String value) {
            addCriterion("car_number <>", value, "carNumber");
            return (Criteria) this;
        }

        public Criteria andCarNumberGreaterThan(String value) {
            addCriterion("car_number >", value, "carNumber");
            return (Criteria) this;
        }

        public Criteria andCarNumberGreaterThanOrEqualTo(String value) {
            addCriterion("car_number >=", value, "carNumber");
            return (Criteria) this;
        }

        public Criteria andCarNumberLessThan(String value) {
            addCriterion("car_number <", value, "carNumber");
            return (Criteria) this;
        }

        public Criteria andCarNumberLessThanOrEqualTo(String value) {
            addCriterion("car_number <=", value, "carNumber");
            return (Criteria) this;
        }

        public Criteria andCarNumberLike(String value) {
            addCriterion("car_number like", value, "carNumber");
            return (Criteria) this;
        }

        public Criteria andCarNumberNotLike(String value) {
            addCriterion("car_number not like", value, "carNumber");
            return (Criteria) this;
        }

        public Criteria andCarNumberIn(List<String> values) {
            addCriterion("car_number in", values, "carNumber");
            return (Criteria) this;
        }

        public Criteria andCarNumberNotIn(List<String> values) {
            addCriterion("car_number not in", values, "carNumber");
            return (Criteria) this;
        }

        public Criteria andCarNumberBetween(String value1, String value2) {
            addCriterion("car_number between", value1, value2, "carNumber");
            return (Criteria) this;
        }

        public Criteria andCarNumberNotBetween(String value1, String value2) {
            addCriterion("car_number not between", value1, value2, "carNumber");
            return (Criteria) this;
        }

        public Criteria andShippingCompanyIsNull() {
            addCriterion("shipping_company is null");
            return (Criteria) this;
        }

        public Criteria andShippingCompanyIsNotNull() {
            addCriterion("shipping_company is not null");
            return (Criteria) this;
        }

        public Criteria andShippingCompanyEqualTo(String value) {
            addCriterion("shipping_company =", value, "shippingCompany");
            return (Criteria) this;
        }

        public Criteria andShippingCompanyNotEqualTo(String value) {
            addCriterion("shipping_company <>", value, "shippingCompany");
            return (Criteria) this;
        }

        public Criteria andShippingCompanyGreaterThan(String value) {
            addCriterion("shipping_company >", value, "shippingCompany");
            return (Criteria) this;
        }

        public Criteria andShippingCompanyGreaterThanOrEqualTo(String value) {
            addCriterion("shipping_company >=", value, "shippingCompany");
            return (Criteria) this;
        }

        public Criteria andShippingCompanyLessThan(String value) {
            addCriterion("shipping_company <", value, "shippingCompany");
            return (Criteria) this;
        }

        public Criteria andShippingCompanyLessThanOrEqualTo(String value) {
            addCriterion("shipping_company <=", value, "shippingCompany");
            return (Criteria) this;
        }

        public Criteria andShippingCompanyLike(String value) {
            addCriterion("shipping_company like", value, "shippingCompany");
            return (Criteria) this;
        }

        public Criteria andShippingCompanyNotLike(String value) {
            addCriterion("shipping_company not like", value, "shippingCompany");
            return (Criteria) this;
        }

        public Criteria andShippingCompanyIn(List<String> values) {
            addCriterion("shipping_company in", values, "shippingCompany");
            return (Criteria) this;
        }

        public Criteria andShippingCompanyNotIn(List<String> values) {
            addCriterion("shipping_company not in", values, "shippingCompany");
            return (Criteria) this;
        }

        public Criteria andShippingCompanyBetween(String value1, String value2) {
            addCriterion("shipping_company between", value1, value2, "shippingCompany");
            return (Criteria) this;
        }

        public Criteria andShippingCompanyNotBetween(String value1, String value2) {
            addCriterion("shipping_company not between", value1, value2, "shippingCompany");
            return (Criteria) this;
        }

        public Criteria andSpecifyDriverNameIsNull() {
            addCriterion("specify_driver_name is null");
            return (Criteria) this;
        }

        public Criteria andSpecifyDriverNameIsNotNull() {
            addCriterion("specify_driver_name is not null");
            return (Criteria) this;
        }

        public Criteria andSpecifyDriverNameEqualTo(String value) {
            addCriterion("specify_driver_name =", value, "specifyDriverName");
            return (Criteria) this;
        }

        public Criteria andSpecifyDriverNameNotEqualTo(String value) {
            addCriterion("specify_driver_name <>", value, "specifyDriverName");
            return (Criteria) this;
        }

        public Criteria andSpecifyDriverNameGreaterThan(String value) {
            addCriterion("specify_driver_name >", value, "specifyDriverName");
            return (Criteria) this;
        }

        public Criteria andSpecifyDriverNameGreaterThanOrEqualTo(String value) {
            addCriterion("specify_driver_name >=", value, "specifyDriverName");
            return (Criteria) this;
        }

        public Criteria andSpecifyDriverNameLessThan(String value) {
            addCriterion("specify_driver_name <", value, "specifyDriverName");
            return (Criteria) this;
        }

        public Criteria andSpecifyDriverNameLessThanOrEqualTo(String value) {
            addCriterion("specify_driver_name <=", value, "specifyDriverName");
            return (Criteria) this;
        }

        public Criteria andSpecifyDriverNameLike(String value) {
            addCriterion("specify_driver_name like", value, "specifyDriverName");
            return (Criteria) this;
        }

        public Criteria andSpecifyDriverNameNotLike(String value) {
            addCriterion("specify_driver_name not like", value, "specifyDriverName");
            return (Criteria) this;
        }

        public Criteria andSpecifyDriverNameIn(List<String> values) {
            addCriterion("specify_driver_name in", values, "specifyDriverName");
            return (Criteria) this;
        }

        public Criteria andSpecifyDriverNameNotIn(List<String> values) {
            addCriterion("specify_driver_name not in", values, "specifyDriverName");
            return (Criteria) this;
        }

        public Criteria andSpecifyDriverNameBetween(String value1, String value2) {
            addCriterion("specify_driver_name between", value1, value2, "specifyDriverName");
            return (Criteria) this;
        }

        public Criteria andSpecifyDriverNameNotBetween(String value1, String value2) {
            addCriterion("specify_driver_name not between", value1, value2, "specifyDriverName");
            return (Criteria) this;
        }

        public Criteria andSpecifyDriverMobileIsNull() {
            addCriterion("specify_driver_mobile is null");
            return (Criteria) this;
        }

        public Criteria andSpecifyDriverMobileIsNotNull() {
            addCriterion("specify_driver_mobile is not null");
            return (Criteria) this;
        }

        public Criteria andSpecifyDriverMobileEqualTo(String value) {
            addCriterion("specify_driver_mobile =", value, "specifyDriverMobile");
            return (Criteria) this;
        }

        public Criteria andSpecifyDriverMobileNotEqualTo(String value) {
            addCriterion("specify_driver_mobile <>", value, "specifyDriverMobile");
            return (Criteria) this;
        }

        public Criteria andSpecifyDriverMobileGreaterThan(String value) {
            addCriterion("specify_driver_mobile >", value, "specifyDriverMobile");
            return (Criteria) this;
        }

        public Criteria andSpecifyDriverMobileGreaterThanOrEqualTo(String value) {
            addCriterion("specify_driver_mobile >=", value, "specifyDriverMobile");
            return (Criteria) this;
        }

        public Criteria andSpecifyDriverMobileLessThan(String value) {
            addCriterion("specify_driver_mobile <", value, "specifyDriverMobile");
            return (Criteria) this;
        }

        public Criteria andSpecifyDriverMobileLessThanOrEqualTo(String value) {
            addCriterion("specify_driver_mobile <=", value, "specifyDriverMobile");
            return (Criteria) this;
        }

        public Criteria andSpecifyDriverMobileLike(String value) {
            addCriterion("specify_driver_mobile like", value, "specifyDriverMobile");
            return (Criteria) this;
        }

        public Criteria andSpecifyDriverMobileNotLike(String value) {
            addCriterion("specify_driver_mobile not like", value, "specifyDriverMobile");
            return (Criteria) this;
        }

        public Criteria andSpecifyDriverMobileIn(List<String> values) {
            addCriterion("specify_driver_mobile in", values, "specifyDriverMobile");
            return (Criteria) this;
        }

        public Criteria andSpecifyDriverMobileNotIn(List<String> values) {
            addCriterion("specify_driver_mobile not in", values, "specifyDriverMobile");
            return (Criteria) this;
        }

        public Criteria andSpecifyDriverMobileBetween(String value1, String value2) {
            addCriterion("specify_driver_mobile between", value1, value2, "specifyDriverMobile");
            return (Criteria) this;
        }

        public Criteria andSpecifyDriverMobileNotBetween(String value1, String value2) {
            addCriterion("specify_driver_mobile not between", value1, value2, "specifyDriverMobile");
            return (Criteria) this;
        }

        public Criteria andSpecifyCarNumberIsNull() {
            addCriterion("specify_car_number is null");
            return (Criteria) this;
        }

        public Criteria andSpecifyCarNumberIsNotNull() {
            addCriterion("specify_car_number is not null");
            return (Criteria) this;
        }

        public Criteria andSpecifyCarNumberEqualTo(String value) {
            addCriterion("specify_car_number =", value, "specifyCarNumber");
            return (Criteria) this;
        }

        public Criteria andSpecifyCarNumberNotEqualTo(String value) {
            addCriterion("specify_car_number <>", value, "specifyCarNumber");
            return (Criteria) this;
        }

        public Criteria andSpecifyCarNumberGreaterThan(String value) {
            addCriterion("specify_car_number >", value, "specifyCarNumber");
            return (Criteria) this;
        }

        public Criteria andSpecifyCarNumberGreaterThanOrEqualTo(String value) {
            addCriterion("specify_car_number >=", value, "specifyCarNumber");
            return (Criteria) this;
        }

        public Criteria andSpecifyCarNumberLessThan(String value) {
            addCriterion("specify_car_number <", value, "specifyCarNumber");
            return (Criteria) this;
        }

        public Criteria andSpecifyCarNumberLessThanOrEqualTo(String value) {
            addCriterion("specify_car_number <=", value, "specifyCarNumber");
            return (Criteria) this;
        }

        public Criteria andSpecifyCarNumberLike(String value) {
            addCriterion("specify_car_number like", value, "specifyCarNumber");
            return (Criteria) this;
        }

        public Criteria andSpecifyCarNumberNotLike(String value) {
            addCriterion("specify_car_number not like", value, "specifyCarNumber");
            return (Criteria) this;
        }

        public Criteria andSpecifyCarNumberIn(List<String> values) {
            addCriterion("specify_car_number in", values, "specifyCarNumber");
            return (Criteria) this;
        }

        public Criteria andSpecifyCarNumberNotIn(List<String> values) {
            addCriterion("specify_car_number not in", values, "specifyCarNumber");
            return (Criteria) this;
        }

        public Criteria andSpecifyCarNumberBetween(String value1, String value2) {
            addCriterion("specify_car_number between", value1, value2, "specifyCarNumber");
            return (Criteria) this;
        }

        public Criteria andSpecifyCarNumberNotBetween(String value1, String value2) {
            addCriterion("specify_car_number not between", value1, value2, "specifyCarNumber");
            return (Criteria) this;
        }
    }

    /**
     * master_order_info
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * @title master_order_info表的实体类
     * @description master_order_info
     * @version 1.0
     * @author yaokan
     * @date 2021-05-26 13:14:01
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}